Password Protecting a Background DB

K

Kathy

I'm splitting databases, and trying to password protect
the _be.mdb. I was certain that I could do that, and
went to help in access and got the following:

""About linking tables from a password-protected database

To link a table from a Microsoft Access database that is
password-protected, you must supply the correct password.
If you supply the correct password, Microsoft Access
stores the database password with the information that
defines the link to the table. After the link has been
defined, any user who can open the database that the
table is linked to can open the linked table. When a user
opens the linked table, Microsoft Access uses the stored
password to open the database where the table is stored.
If the password is changed for the database where the
table is stored, the next time the linked table is
opened, the new password must be supplied before
Microsoft Access will open it.""

Unfortunately, When the _be.mdb is password protected and
I try to open the front end mdb, I get a message telling
me that was an invalid password.

Thanks for any help.
 
J

Joan Wild

You need to delete the links in the frontend. Then re-establish them.
You'll be prompted for the password to the backend.
 

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