transferdatabase

S

search

What Do I wrong ?

I tried to link a odbc.table to an access database?
When I link it manually it works fine!


DoCmd.TransferDatabase acLink, "ODBC Database", _
"ODBC;DSN=mydsn;UID=user1;PWD=password;" _
& "DATABASE=C:\Access\test.mdb acTable, "name table in oracle", "name table
in access"



thx in advance
 

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

Setting the primary key when using DoCmd.TransferDatabase acLink 3
Table Security in Access 2013 1
Trying to query ODBC source without linked table 2
Access 2007 - DoCmd.TransferDatabase not saving UID and PW 2
language issue with DoCmd.TransferDatabase 6
Delete a backend table 2
ODBC Connection 0
transferdatabase 2

Top