Others

How to Convert Access MDB to ACCDB with User Permissions

WPS Content Manager Sep 27, 2026 869 views

Question details

The user needs a method to retain or recreate department-specific user permissions when converting an older Microsoft Access MDB database to the newer ACCDB format.

Convert an Access MDB Database to ACCDB with User Permissions

Product: Microsoft Access
Device & OS: not provided
Scenario: Upgrading a legacy MDB file to the ACCDB format while ensuring that specific tables, forms, and sections remain restricted to authorized department personnel.
Observed behavior: The ACCDB format drops support for the legacy User-Level Security (MDW workgroup files) present in MDB databases, breaking existing authorization mechanisms.

Before you start

Before converting your database, ensure you have completely backed up the original MDB file and its associated MDW workgroup file, as the built-in user-level security features will be permanently stripped during the ACCDB conversion.

Solution 1Recommended

Create a Custom Login Form with VBA Authentication

Since ACCDB does not support traditional User-Level Security, you must build an application-level security system using custom user tables and VBA.

Because the ACCDB format relies on a newer database engine that deprecated User-Level Security, you cannot directly migrate MDW file permissions. Instead, you must authenticate users through a custom startup form and use VBA to restrict navigation based on their assigned department roles.

Convert the Database Format

Open your MDB file in Microsoft Access, navigate to File > Save As, choose 'Access Database (*.accdb)', and save the new file.

Create a User Credentials Table

Create a new local table (e.g., tblUsers) containing fields for UserID, Username, PasswordHash, and DepartmentRole. Populate it with your authorized users.

Design a Login Form

Create an unbound form (e.g., frmLogin) with text boxes for Username and Password, and a 'Login' command button.

Write VBA Authentication Code

In the OnClick event of the Login button, write VBA code to use DLookup to verify if the entered Username and Password match a record in tblUsers.

Assign Permissions via Global Variables

If authentication succeeds, store the user's DepartmentRole in a TempVar or global variable. Use this variable in the OnOpen events of your department-specific forms to either allow access or display a 'Permission Denied' message.

Set Startup Options

Go to File > Options > Current Database, and set your new login form as the 'Display Form' so it opens automatically when the database launches.

Create a Custom Login Form with VBA Authentication

Security Limitation: Keep in mind that this is application-level security, not database-level encryption. Users who know how to hold the Shift key during startup or access the navigation pane might still bypass the forms and view the underlying tables directly.

Free Microsoft Office alternative

Manage Your Daily Data and Documents with WPS Office

While complex relational databases requiring VBA security are best managed in Microsoft Access, you can handle all your everyday data lists, spreadsheets, and document processing needs effortlessly with WPS Office. It is a free, lightweight suite that serves as a powerful alternative to Microsoft Office.

1. Download and Install: Visit the official WPS Office website to download the free, lightweight installer.
2. Import Your Data: Open WPS Spreadsheet to import exported CSV or Excel files from your database for quick analysis.
3. Protect Your Data: Use the 'Review' tab to easily protect sheets and workbooks with passwords, restricting unauthorized access to your tabular data.

Fully compatible with Microsoft Excel, Word, and PowerPoint formats (.xlsx, .docx, .pptx)Lightweight application that runs smoothly on standard PCs without slowing down your systemFeatures a familiar, easy-to-use tabbed interface for seamless migrationManage robust data lists securely using built-in spreadsheet protections instead of complex VBA

microsoft office alternative - wps office

Frequently Asked Questions

Why did Microsoft remove User-Level Security in the ACCDB format?

Microsoft removed the legacy User-Level Security (MDW) in the ACCDB format because the architecture was outdated and easily compromised by modern password-cracking tools. They recommend using SQL Server, Windows SharePoint Services, or building custom VBA security for access control.

Can I still use my MDB file with newer versions of Access?

Yes, modern versions of Microsoft Access can still open, read, and run older MDB files. However, you will not be able to utilize newer features like multi-valued fields, attachment data types, or newer encryption methods until you convert the file to ACCDB.

Is there a way to password-protect an entire ACCDB file easily?

Yes, you can encrypt the entire database with a single password. Open the ACCDB file in Exclusive Mode (File > Open > Open Exclusive), then navigate to File > Info and click 'Encrypt with Password'. Note that this restricts the whole file but does not provide individual or department-level permissions.

Office Quick Solutions