About linking tables from a password-protected database (MDB)
Note The information in this topic applies only to a Microsoft Access database (.mdb).
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 database with the link to the 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 database with the link to the table is opened, the new password must be supplied before Microsoft Access will open it.
Microsoft Access stores the database password information for the linked table in an unencrypted form. If this will compromise the security of the password-protected database, you should not use a database password to help protect the database. Instead, you should define user-level security to help control access to sensitive data in that database.