ODBC error

[Rich]

Hello,

I'm trying to run the following and get the error "The
Microsoft Jet database engine could not find the
object 'admin_prices'...I'm a novice so step by step would
be greatly appreciated

DoCmd.TransferDatabase acImport, "ODBC Database", _
"ODBC;DSN=CmTS1;UID=Admin;PWD="";LANGUAGE=us_english;" _
& "DATABASE=CmTS1", acTable, "admin_prices", "dboPx"

 

[Van T. Dinh]

Try:

DoCmd.TransferDatabase acImport, "ODBC Database", _
"ODBC;DSN=CmTS1;UID=Admin;PWD=;LANGUAGE=us_english;" _
& "DATABASE=CmTS1", acTable, "admin_prices", "dboPx"

If that doesn't work:

1. Check and make sure your DSN 'CmTS1' works correctly
with the above UID and PWD. Note that "Admin" may be a
user in Access only and not a user in the ODBC database.

2. Confirm that you do have a Database CmTS1 and
Table "admin_prices".

The syntax looks OK and I tested with my set-up and it
works fine with proper UID & PWD.

HTH
Van T. Dinh
MVP (Access)