When linking to the FoxPro tables from Access 97 I see the tables, but when I double-click on the tables I get #ERROR in every field. Can you please explain what the problem is?
From the description you provide, I can think of two possibilities:
- When you are creating the ODBC DSN to access the tables, you may have chosen the wrong driver.
- You might not have the correct VFP ODBC driver installed on the machine. You may be trying to access a VFP version 6 table with VFP version 5 driver.