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 (link (tables): An action that establishes a connection to data from another application so that you can view and edit the data in both the original application and in Access.) a table from a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) that is password-protected, you must supply the correct password (password: A sequence of characters needed to access computer systems, files, and Internet services. Strong passwords combine uppercase and lowercase letters, numbers, and symbols.). 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 (user-level security: When using user-level security in an Access database, a database administrator or an object's owner can grant individual users or groups of users specific permissions to tables, queries, forms, reports, and macros.) to help control access to sensitive data in that database.

Applies to:
Access 2003