Upgrading from Access 97 to 2000

[EdMaste]

When upgrading an application developed in Access 97 to Access 2000 I can not link to Foxpro 2.6 .dbf tables anymore. Access 2000 tells me that the Foxpro driver is no longer supported and to use the visual Foxpro driver. Unfortunately this does not work, the only way around this problem is to import the table instead of linking the table.
But this "solution" is not an option. One of the tables is 500 MB and this would have to be copied daily. Does anyone have a suggestion as to how I can again link these tables?

 

[PaulF]

one thing to check is ensure that you:

Use a Machine DSN (that is a User or System DSN) instead of a File DSN.

this is from

http://support.microsoft.com/support/kb/articles/Q212/8/86.ASP?LN=EN-US&SD=SO&FR=0

also see

ACC2000: No Option to Import, Link, or Export to the FoxPro File Type

http://support.microsoft.com/support/kb/articles/Q225/8/61.ASP?LN=EN-US&SD=SO&FR=0

PaulF

 

[EdMaste]

Thanks Paul
After your answer I followed the links and am now running the program under Access 2000.