I have been trying to get this working now for a while but not having any success.... If someone can take a quick look and provide some insight I would really appreciate it.
What I am trying to do is automate the importing of a table from an Oracle database to my local access database.
When running the following code, I receive runtime error 3151 ODBC Connection to 'GetPaid_7i.dsn' failed.
DoCmd.TransferDatabase acImport, "odbc", "ODBC;dsn=GetPAID_7i.dsn;UID=XXXX;PWD=XXXX;LANGUAGE=us_english;", acTable, "GPCOMP1_GPCUST", "TEST"
I have verified that the user name and password is correct. Please let me know if you can assist. Thanks!
expression.Transferdatabase(transfertype, databasetype, databasename, objecttype,source, destination, structureonly, storelogin.