Error Inserting / Updating an Access Db

[TonyCronin]

Hi,

I am having a nightmare trying to insert and update a table in an Access Db. It is a form with around twenty elements on it and I cant get it to work due to an error in some code created by Ultradev. Im not sure if table / database or code is the problem. Has anyone seen anything like this / have any tips on sorting it?

Thanks,
Tony (TCr9089141@aol.com)

Error is.........

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

/Page_Index/Product/Test/Type/edit_client.asp, line 90

....end

Line 90 is....

If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command&quot
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
90->MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close

...end. This code is created by UD...

 

[Cheech]

Need to see the SQL UPDATE statement, looks like you are using "&" instead of "+" or the other way round. I dont want to go to Chelsea!!!

 

[haslo]

Access and Ultradev have a problem with some default values - I think it was something with NULL values that Access does not understand. Try pasting the SQL code UD created (via

Response.Write(MM_editQuery)

) and paste it here. Maybe i will remember then (I now work with MS SQL Server instead of Access...)

allow thyself to be the spark that lights the fire
haslo@haslo.ch - www.haslo.ch​

 

[TonyCronin]

Hi,

I have figured it out. I had a field called E-Mail - with a '-' sign in it. I put [] around the SQL and it work fine. Illegal character!!

Thanks for all your help,
Tony