>>Have you tried this with autoinc, logical, and date fields? I can get it to work with 1 table in the dbc but not another.
>
>VFP ODBC driver does not support any new data features (like autoinc, etc.) introduced in VFP7 and later. Only VFP OLE DB provider supports them.

Thanks Sergey. I had concluded that it was the autoinc field that was causing the problem. Do you know if the OLEDB driver can be used from the Access interface or does it require code?