Kevin,

Well, I tinkered around with it and managed to get a different, syntax error now, although I cannot figure out why I'm getting it. Now the error occurs on the insert command. The entire stack trace is listed below.

I created business objects for the message table, thinking that might be the problem but I still get the same error.

Thanks.

Linda

Server Error in '/Catholic Archive System Web CSharp' Application.
--------------------------------------------------------------------------------

Syntax error. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.OleDb.OleDbException: Syntax error.

Source Error: 


Line 176:        }
Line 177:
Line 178:        mmAppBase.MessageMgr.SaveTranslatedText(OriginalText, this.txtTranslatedText.Text, Language,
Line 179:            this.chkShowSystemMessages.Checked);
Line 180:        //        mmAppBase.MessageMgr.SaveTranslatedText(OriginalText, this.txtTranslatedText.Text, Language,
 

Source File: c:\deve\Catholic Archive System\Catholic Archive System Web CSharp\Admin\LanguageConfiguration.aspx.cs    Line: 178 

Stack Trace: 


[OleDbException (0x80040e14): Syntax error.]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +65
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +181
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +307
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +77
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +188
   System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +112
   OakLeaf.MM.Main.Data.mmDataAccessBase.ExecNonQuery(String command, IDbDataParameter[] dataParams) +306
   OakLeaf.MM.Main.Business.mmBusinessObject.ExecNonQuery(String command, String databaseKey, IDbDataParameter[] dataParams) +81
   OakLeaf.MM.Main.Business.mmBusinessObject.ExecNonQuery(String command, IDbDataParameter[] dataParams) +79
   OakLeaf.MM.Main.Globalization.mmMessageManager.SaveTranslatedText(String messageKey, String translatedText, Object languagePK, Boolean DialogText) +952
   LanguageConfiguration.btnSave_Click(Object sender, EventArgs e) in c:\deve\Catholic Archive System\Catholic Archive System Web CSharp\Admin\LanguageConfiguration.aspx.cs:178
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +96
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +116
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +31
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +72
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3839

 


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42