Chuck;

Can you post the actual code? That will help figure out the problem.

>I am using an ADO record set to acess VFP's tables,but when I do an update I get an error [OLE IDispatch exception code 0 from Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword...]. I checked the supports method and it says it supports Update. The ADO record set cursor type is KeySet and the LockType is Optimistic and the cursor location is UseClient. The rest is default. Any Help?