Link tables to password-protected database using VBA

  • Thread starter Thread starter Jerome Smith
  • Start date Start date
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
 
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
 
Back
Top