>I have found that the ODBC driver for FoxPro will not read tables with an Auto Increment field in it. I was attempting to link Fox Tables in Access for a client and found that the list of tables in the directory to link to did not include those select few tables that have this unique feature. I have installed the OLEDB for v9 and have the latest MDAC 2.8. Have I found a bug or does someone know what I need to do to fix this?

ODBC driver was not upgraded since VFP6, so it doesn't support all new features added later, such as AutoInc fields, for example.

See Re: VFP 9.0 remote views and ODBC driver Thread #1169729 Message #1169771