Microsoft Access has two types of protection: a password to open and a user-level security. The type of password protection determines the level of user access to the database and its objects.
Database password (share-level password or password to open)
When a password for opening is set, all users must enter that password before they are allowed to open the database. Setting a password protects the database from access by unauthorized users.
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.
Access Password Recovery supports all of them and instantly recovers the password protection.