Link ForPro table with TransferDatabase


M

Marko

I'm reworking an old Access 2000 database that links to a FoxPro table
and have encountered a problem. On my old PC linking to FoxPro worked
using:
DoCmd.TransferDatabase acLink, "dBase III", strAMWorkflowPath, acTable,
Forms!frmmain!txtAMWdb, "tbkAMW"

Now on new PC with Access 2003 same command brings up error:
Unexpected Error from External database driver (8961).

I have seen there is some reference to using ODBC to connect to FoxPro
now instead.
I thus downloaded and installed the latest Microsoft Visual foxpro ODBC
Driver

Using command line:
DoCmd.TransferDatabase acLink, "ODBC", "ODBC;DSN=Visual Foxpro
Tables;SourceDB=c:aaa;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;",
acTable, strFPTableName,"tbkAMW", False

gives error message of:
The Microsoft Jet database engine could not find the object.......
If the strFPTableName does not contain extension ".DBF"

If I do put the extension in the filename then get a different error
message:
[Microsoft][ODBC Visual FoxPro Driver]Driver not capable (#0)

Now,
I can manually link to the table from the File -> Get External Data ->
Link.....etc menu, but need to do this via code. (has to be possible..)

Any assistance would be much appreciated.

Mark
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top