Link tables to password-protected database using VBA

J

Jerome Smith

Hello all,

How does one, in VBA, link tables to a password-protected database? I use
the following code:

DoCmd.TransferDatabase acLink, "Microsoft Access", "DB.mdb", acTable,
"Table", "Table"

DB.mdb is protected with a password; therefore this code asks the user for
the password. How does one incorporate the password into this code?

Thanks in advance,

Jerome Smith
 
E

Eric Butts

Hi,

Here's an example of linking to a database that is password protected:

275249 ACC2000: How to Use ADOX to Create and Refresh Linked Jet Tables
http://support.microsoft.com/?id=275249


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top