I created a simple CA for a Simple table. I can get that to work (insert/update/delete) this works just fine, however, when add code for my larger table (only things that have changed are the insertcmd, updatecmd and schema), i get the following: "Microsoft OLE DB Provider for Visual FoxPro : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." I know the Schema is correct because it's the same schema i use for ODBC. The rest of the CA is identical to the simple CA i created and works.

Any clue anyone. BTW, I am running VFP8 SP1

Mark