Linking Tables from Password Protected DB

[Becky N]

Hello,

I have an access 2003 db (DB1) that is password protected and I want to
create a new db (DB2) that has two tables from DB1 linked to it. When the
users open DB2 there is a form with buttons that will call up other forms
that contain data based on the linked tables from DB1. However, when they
press the buttons they get the error "invalid password" since they have not
entered the password from DB1.

Is there some vba code or a macro I can create that can program in the
password from DB1 so that they can access the data from the linked tables in
DB2?

Thank you for your help!

Becky N

 

[M Skabialka]

I had a database set up like that: When I linked the second database the
first time it asked for a passwrod which I supplied, and the users never had
to enter it. No-one could open that second database directly without using
a password.
Mich

 

[M Skabialka]

I had a database set up like that: When I linked the second database the
first time it asked for a passwrod which I supplied, and the users never had
to enter it. No-one could open that second database directly without using
a password.
Mich