User-level security

If user-level protection is defined for the workgroup, user accounts can be used. 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. Information about users and their passwords is not stored in the database itself, but in a separate workgroup file.

If you encounter the enter password dialog (see below) when opening the database in Microsoft Access, it means that the database is password-protected.

Logon Dialog

Unlike the password to open dialog, a workgroup member name is also requested.

Access Password Recovery recovers all user accounts and their passwords for the workgroup file.

If your user account has limited privileges, you will get a warning when trying to access some items: "You don't have permissions to modify, import or export."

Information about groups and users is instantly recovered by the Access Password Recovery program. This allows you to access the database with administrator (or other privileged user) rights.

If the workgroup file is lost or corrupted, the following warning will appear: "You do not have the necessary permissions to use the name object. Have your system administrator or the person who created this object establish the appropriate permissions for you."

Access Password Recovery instantly recovers all necessary information about the owners of database items and their privileges. That allows for easy recovery of the workgroup file.

Access Password Recovery Help. (c) 2007 Intelore.