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
 

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

Similar Threads

Importing FoxPro 2.6 DBF Into Access 2007 1
Using ODBC import 1
TransferDatabase command, link DBF from DBC to Access 2003 0
Import MS VisualFoxPro Table into Access database 0
Linked Foxpro tables not editable? 0
Problem Linking Foxpro 9 .DBC in Access 2003 7
Error Linking to VFP Tables 3
cannot link Foxpro file as table, access2000 3

Top