FOUND THE PROBLEM!!! (reply)
You are right, next and filter do not work well, but doesn't this prove
a point that the reserved list is adhered too, and that this is another
problem?
------------
Jim Presley at 5/9/00 3:05:28 PM
Mark, I inserted dbRESET right after the SQL statement, and that appears
to have fixed it.
------------
Jim Presley at 5/9/00 9:37:53 AM
I all of a sudden receive this error when updating records, I have
checked the tables for reserved words and find none.
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
FOUND THE PROBLEM!!! (reply)
Jim,
I don't think we've proved anything yet. I still haven't seen your source code and I would really appreciate it if you could email us a simple asp and mdb file that demonstrates your problem. Also, please set dbDebug=101 and try it again. 101 will dump the exact SQL that was trying to run at the time of the error. You can then copy it off your screen and paste it into an Access Query and let Access try to run it. Access will give you a better clue as to exactly where in the SQL the syntax error is occurring.
Mark.
------------
Jim Presley at 5/9/00 4:35:51 PM
You are right, next and filter do not work well, but doesn't this prove
a point that the reserved list is adhered too, and that this is another
problem?
------------
Jim Presley at 5/9/00 3:05:28 PM
Mark, I inserted dbRESET right after the SQL statement, and that appears
to have fixed it.
------------
Jim Presley at 5/9/00 9:37:53 AM
I all of a sudden receive this error when updating records, I have
checked the tables for reserved words and find none.
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503
Sent E-mail with attachments
Mark, I sent you copies via E-mail
------------
Jim Presley at 5/9/00 9:37:53 AM
I all of a sudden receive this error when updating records, I have
checked the tables for reserved words and find none.
Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503