Link ForPro table with TransferDatabase



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
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

Using command line:
DoCmd.TransferDatabase acLink, "ODBC", "ODBC;DSN=Visual Foxpro
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
[Microsoft][ODBC Visual FoxPro Driver]Driver not capable (#0)

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.



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