Using Access 97 to Connect to FoxPro Tables

Question:
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?

Answer:
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.
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: