TransferDatabase command, link DBF from DBC to Access 2003


M

MINHHAI

Dear,

I have got a problem when to do this command:
docmd.TransferDatabase acLink, "ODBC Database","ODBC;DSN=Visual FoxPro
Database;SourceDB=P:\data\Acc2007.dbc;SourceType=DBC",acTable,"DAcc0307.dbf","tblAcc0307"

The problem is "Runtime error 3146"
"ODBC -- call failed"
"[Microsoft][ODBC Visual FoxPro Driver]Driver not capable (#0)"

But manually I can link or import a DBF from DBC file.

Your help is highly appreciated.

Thank you very much.
 
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