TransferDatabase

[Newbie24]

Hi all

I have a question regarding the importing of a ODBC database.Here is my code:

DoCmd.TransferDatabase acImport, "ODBC Database", "ODBC;DSN=TraderDatabase;UID=SYSDBA;PWD=INT7753931;LANGUAGE=us_english;" _
 & "DATABASE=tcv2230:TraderDatabase", acTable, "Products", "TestTable", False, True
 

As soon as click the button to perform the import I get a error message:Run time error Microsoft jet database enjin could not find the object TestTable.Make sure the object exists and that you spell it's name and path correctly

Any help on this would be appreciated.

[NeoPa]

I think the DatabaseType parameter (2nd) should be "ODBC Databases".

[Newbie24]

Thnx,I tried it but now the error message is:The ODBC Databases type isn't an installed database type or doesn't support the operation you chose.I am quite new to the coding in ACCESS.I am sure there is just something that I am missing somewhere,but don't seem to figure it out.

[NeoPa]

I'm afraid I can't be much more help as ODBC is very specific to the type. I know one ODBC driver that I've used at work, but the parameters for that one are quite different from most others.

I suggest you try to get some help from the vendor of the ODBC driver. They should be able to help, but as this is so specific it's not likely too many will have the experience to be able to help I'm afraid.

[MMcCarthy]

Have you tried linking directly to the table using the link table wizard? I'm wondering if there is a problem with the DSN setup.

See if you can create a working link manually so we can move on to looking at syntax if you can.