Permission & Access Issues

How to Disable the Shift Key and Protect an Access Database

Phi Hung VoPhi Hung Vo Nov 4, 2026 870 views

Question details

The user needs to prevent end users from bypassing Microsoft Access startup options using the Shift key, restrict modifications to the application design, and understand the limits of preventing unauthorized database copying.

How to Disable the Shift Key and Protect an Access Database
Product
Microsoft Access
Device & OS
not provided
Scenario
Distributing a shared Access database application to end users securely while locking down its startup routines and design layout.
Observed behavior
The goal is to secure the database by disabling the bypass key, converting the front-end to a compiled executable format (ACCDE), and applying appropriate environment-level data controls.
Before you start

Always create a secure backup copy of your original ACCDB database file before disabling the bypass key or converting it to an ACCDE file, as you will need the original file to make any future design or code modifications.

Solution 1Recommended

Disable the Startup Bypass Key and Compile to ACCDE Format

Use VBA to disable the Shift key bypass so users cannot skip your custom startup routines, then lock the application's design by saving it as a compiled ACCDE file.

Disabling the 'AllowBypassKey' property ensures users must go through your designed startup forms and logic without holding Shift to bypass them. Following this up by compiling the file to ACCDE restricts users from modifying forms, reports, or accessing the VBA source code.

Keep in mind that while you can lock the application interface, users still require full read/write network permissions to interact with a shared Access database. Because of this operating system requirement, you cannot completely restrict users from copying the database backend file.

1
Open the VBA Editor

Open your original database in Microsoft Access, press ALT + F11 to open the Visual Basic for Applications (VBA) editor, and click 'Insert' > 'Module'.

2
Add Bypass Key Code

Write or paste a VBA function that sets the 'AllowBypassKey' property of the CurrentDb object to False. Save the module.

3
Execute the Code

Run the VBA function to apply the security property, which will disable the Shift key bypass for this specific database.

4
Convert to ACCDE

Navigate to the 'File' menu, select 'Save As', choose 'Make ACCDE' under the Advanced options, and click 'Save As'.

5
Distribute the Application

Distribute the newly created ACCDE file to your end users. Ensure you securely store the original ACCDB file for any future updates.

Disable the Startup Bypass Key and Compile to ACCDE Format
Network Permission Limitations: Because standard shared Access databases require users to have file modification permissions on the hosting network drive, standard software protections cannot reliably stop users from copying or moving the backend file.
Free Microsoft Office alternative

Looking for a Free Office Suite? Try WPS Office

While Microsoft Access is a specialized database tool, WPS Office provides a powerful, free alternative for your daily document, spreadsheet, and presentation needs. It is fully compatible with Microsoft Word, Excel, and PowerPoint formats, making your workflow seamless and highly cost-effective.

  1. 1. Download the Installer: Visit the official WPS Office website and download the free installer for your operating system.
  2. 2. Install WPS Office: Run the downloaded installer and follow the quick setup guide to install the lightweight suite.
  3. 3. Open Your Files: Double-click your existing Word, Excel, or PowerPoint files to open them seamlessly within WPS Office.
Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx)Lightweight and runs smoothly on Windows, Mac, Linux, and mobile devicesFamiliar, intuitive user interface for a zero-learning-curve migrationFree built-in PDF editing and format conversion tools
microsoft office alternative - wps office

Frequently Asked Questions

Can the Shift key bypass be re-enabled once it is disabled?

Yes. An advanced user with access to VBA and the correct database file path can write an external script to change the AllowBypassKey property back to True, provided the database backend is not fully encrypted or securely restricted by Windows permissions.

Why can't I prevent users from copying a shared Access database?

Microsoft Access is a file-based database system. For users to read, lock records, and update data, Windows requires them to have full read, write, and execute permissions on the network folder containing the file. These same permissions inherently allow users to copy the file to another location.

What is the difference between ACCDB and ACCDE file formats?

An ACCDB file is the standard database format that contains all editable design elements. An ACCDE file is a compiled 'execute-only' version that strips out editable source code for VBA, forms, and reports, protecting your application's proprietary design from user modification.

How else can I secure the data inside the Access database?

In addition to converting the application to an ACCDE file and disabling the Shift key bypass, you should host the back-end data file on a secure, restricted network share. You can also use the native 'Encrypt with Password' feature in Access to add an extra layer of data security.