Sandy,
Most likely DESC is a key word in Access (it is in SQL Server and VFP). Rename the field and try it again.
HTH.
>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
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao