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?
Jeff Pearce