Originally Posted by
NTC
that would a tough approach I am thinking off hand.
haven't had the need to dig into odbc connection syntax in a long time - - is there an area for password in the connection string itself? just wondering outloud.
obviously getting security permission from the otherside so the prompt isn't there would be the solid fix but am guessing that may be out of your hands...
sorry not to be more helpful on this one.
Turned out to be a very simple approach. Thanks for the tip! Below is the solution.
Code:
DoCmd.TransferDatabase acLink, "ODBC Database", _
"ODBC;DSN=[Enter ODBC Server];UID=[User2];PWD=[Password];" _
& "DATABASE=pubs", acTable, [Enter ODBC Table Name], [Enter Name of Table in Access]