Link to Database - Password

[learning_codes]

HI,

I have two database in two different folder. One (Database A) of the
folder contains all the tables only. Other one is where I use the
database (Database B) everyday and the database is linking the other
database that has all the tables only.

I set the Database B linking to Database A. Database A has a
password to protect. When I open Database B and want to get some
data from Database A but it prompt the password. How to override the
password prompt but still want the basabase A to have password.

Can you provide and help me how to create code ?

Thanks

 

[Tom van Stiphout]

On Sat, 31 Oct 2009 04:20:59 -0700 (PDT), "(e-mail address removed)"

You need a connection string, for example from here:
http://www.connectionstrings.com/access
With that, you can set the Connect property of each attached table,
and call its RefreshLink method.

-Tom.
Microsoft Access MVP