G
Glen Bodie
Access 2002 on Win2k. FoxPro DBF/CDX/FPT data files (free
tables) in a directory. Visual FoxPro V8 driver. Create
System DSN with this driver but do NOT point it to any
particular directory. Check in Registry and SourceDB is
empty.
In Access create a module with code that builds an ODBC
connect string which references that System DSN and uses
it to TransferDatabase-import the FoxPro data into Access.
It works. Now change only the SourceDB parameter in the
connect string and try again. Error messages - none of
which are particularly helpful.
Close Access, restart, provide the 2nd directory first and
it works fine, then try the previously first directory and
get the same errors. All I can infer is that Access has
remembered the parameters on the first connect string and
DOES NOT overlay them with the parameters from the second.
Is that correct, or expected? I couldn't find anything
that let me "clear" that "cache".
tables) in a directory. Visual FoxPro V8 driver. Create
System DSN with this driver but do NOT point it to any
particular directory. Check in Registry and SourceDB is
empty.
In Access create a module with code that builds an ODBC
connect string which references that System DSN and uses
it to TransferDatabase-import the FoxPro data into Access.
It works. Now change only the SourceDB parameter in the
connect string and try again. Error messages - none of
which are particularly helpful.
Close Access, restart, provide the 2nd directory first and
it works fine, then try the previously first directory and
get the same errors. All I can infer is that Access has
remembered the parameters on the first connect string and
DOES NOT overlay them with the parameters from the second.
Is that correct, or expected? I couldn't find anything
that let me "clear" that "cache".