Jim,

It sure sounds like a reserved word problem. Anyway, do this:
Turn on debug (X.dbDebug=4 or 101) to see what the exact SQL that is trying to execute. Take a close look at it and/or show it to us.

ALSO … Be sure the TableName doesn’t have a "minus sign" in it. such as [RES-FLD-NAMES].

Mark.


------------
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