Password Protecting a Background DB

  • Thread starter Thread starter Kathy
  • Start date Start date
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.
 
You need to delete the links in the frontend. Then re-establish them.
You'll be prompted for the password to the backend.
 
Back
Top