Sorry, Neil... nothing's jumping out at me. Don't have much experience w/oledbprovider, tho' so it may be obvious and still going right by me.

I have a feeling your best bet is to see the exact command string being sent to VFP through the data adapter.

---J


>Thank you. I do however have a little more info about this syntax error. I changed the structure of the data file to avoid using auto-incrementing integer unique field. Now my unique field is a Character field.
>Guess what? Same syntax error. Please review my customdataclass and see if my code is up to stuff.
>
>Regards,
>Neil