Hello All,
Message() returns "Connectivity Error[Microsoft][ODBC Microsoft access Driver] Syntax error in Insert Into Statement"

Using a VFP6, I use my connection to update on this database 6 other tables with no real problems only on this one table do I have this issue. Yes, the checkbox is selected in "Send SQL Updates" i nthe modify of the view.

The fields are tstatus c(10),filename c(30), name c(30), date c(10), desc c(2), and id N (in access this is a long integer). The table is indexed in ID
and no duplicates are allowed. Buffering in set to 5, and multilocks are on.
My prodedure of next_id verfies that when I add a new record, id is unique.

When I try to edit a record, I get the same message.

Any ideas of where to search or try to resolve this puzzle would be GREATLY appreciated.

Sandy

Any