>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.