Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

User-level security features are not available in Access web apps, web databases, or databases that use one of the new file formats (.accdb, .accde, .accdc, .accdr).

You can continue to manage user-level security in Access desktop database files that use an earlier Access file format (such as an .mdb or .ade file). We recommend this only if you already have a user-level security solution in place that you want to keep using.

Note: In current versions of Access, if you use the User-Level Security wizard to specify a default workgroup information file, you must also use the /WRKGP command-line switch to point to your workgroup information file when you start Access. For more information about using a command-line switch with Access, see the article Command-line switches for Microsoft Office products.

Manage user-level security for an earlier-format database file

Note: Do not convert your database to one of the new file formats if you want to continue using user-level security. The user-level security features work only in databases that use an earlier Access file format, such as .mdb files.

  1. Open the database that has user-level security settings that you want to manage.

  2. On the Database Tools tab, in the Administer group, click Users and Permissions.

  3. Click one of the following commands:

    • User and Group Permissions    Use this to grant or revoke user or group permissions, or to change the owner of database objects.

    • User and Group Accounts    Use this to create or delete a user or a group, to change the password or the group membership of a user, or to change the database Logon password.

    • User-level Security Wizard    Use this to start the Security Wizard, which makes an unsecured backup copy of your database and guides you through the process of implementing user-level security features.

      Note: These commands are not available in databases that use one of the new file formats.

Other security features

For better security, consider using one or more of the following features:

  • Encryption    The encryption tool makes your data unreadable by other programs or tools, and it forces users to enter a password to use the database. The encryption tool is available only in databases that use one of the new file formats. In Access, click File > Encrypt with Password.

  • Database server    Store your data on a database server that manages user security, such as Microsoft SQL Server. Then, use Access to build queries, forms, and reports by linking to the data on the server. You can use this technique on a database saved in any Access file format.

  • SharePoint site    SharePoint provides user security and other useful features, such as working offline. There are a variety of implementation options, depending on which SharePoint product you use. Some SharePoint integration features are available only in databases that use one of the new file formats.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×