TransferDatabase creating link to PWD protected mdb

[alfalf]

Hello all.

I need to link an table from pwd protected mdb.

I use TransferDatabase method to perform that, but can't guess proper syntax to link an table from PWD protected database without having db_pwd dialog to popup.

I need to automate linking, on one side, and I have pwd protected database on another side, and code I use is:

DoCmd.TransferDatabase acImport, "Microsoft Access"C:\con_project\main.mdb", acTable, "SER_PRO_AREAS", "ImportedbyCode"

If anyone can help me on syntax with PWD involved!


Thanks

 

[PHV]

With an ODBC connection string you may supply UID and PWD.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[alfalf]

Hey, PHV thx.

No use of that.
But since I switched to dbs that are not pwd protected (I found out that there's no way one could Transfer a db without popup DB dialogue), this is not an issue. Yap, ODBC conn. allows pdw supply, but only for non Microsoft Access databases.

Thanks anyway.