Transfer Databatase

[sukonik]

Hello everyone,

I am trying to connect to a ODBC connection for another DB. I am trying
to run it on startup so I connect before any data is looked at, if the
connection is not achieved I quit the database. I can't get it working.
Here is some information.

ODBC Name = Calls
UID=userSukonik
PWD=sukonik
source table = "dbo.d_input_map_define"
dest table = "dbo_d_input_map_define"

It works fine if I manually connect.

Here is the code.


Code:
--------------------


DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DSN=Calls;UID=userSukonik;PWD=sukonik", acTable, "dbo.d_input_map_define", "dbo_d_input_map_define"

--------------------


Any help greatly appreciated this is really annoying me!!!

Carl