If a link to a visual foxpro table is created using a connect string containing both a DSN reference and an explicit path to the visual foxpro data folder the table links and opens using the settings from the DSN. The only way the explicit link comes into play is after msaccess is restarted. Closing the database does not help.

This is a typical connect string used:
ODBC;DSN=SPCS_TFE;Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=C:\spcs_administra tion\Adm2000\TFE_2007_1;Exclusive=No;Collate=Machi ne;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO;

Have tested tabledefs.refresh etc. Nothing helps only application restart.

Without seeing your actual code used, it will be hard to spot the issue.

Please post the actual VBA code you are using.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com