VBA & Macro Problems

How to Fix Access Event Procedures Failing on Another Computer

Camila MilosovichCamila Milosovich Nov 3, 2026 869 views

Question details

The user needs to resolve an issue where an Access 365 ACCDB database functions correctly on one computer but fails to execute event procedures and VBA code when moved to another.

Fix Access Event Procedures Failing on Another Computer
Product
Microsoft Access 365
Device & OS
not provided
Scenario
Migrating or copying an existing ACCDB database that relies on event procedures to a different computer.
Observed behavior
Event procedures and macros fail to run on the new PC, frequently caused by restricted Trust Center settings, unmatched architecture bitness, or missing VBA references.
Before you start

Verify that the Microsoft Access installation on the new computer matches the bitness (32-bit or 64-bit) of the original computer, as architecture mismatches are a common cause of VBA compilation errors.

Solution 1Recommended

Configure Trust Center and Trusted Locations

Adjusting the Trust Center settings is the most effective way to unblock macros and event procedures restricted by Microsoft Access security on a new computer.

By default, Access blocks executable code and event procedures in databases opened from unverified locations. Adding the database's new folder path to the Trusted Locations list allows the VBA code to run securely without constant prompts.

1
Open Trust Center Settings

Launch Microsoft Access on the affected computer. Go to 'File' > 'Options' > 'Trust Center', and then click the 'Trust Center Settings' button.

2
Add a Trusted Location

Select 'Trusted Locations' from the left sidebar and click 'Add new location'. Browse to the folder where your copied ACCDB file is stored.

3
Include Subfolders

Check the box that says 'Subfolders of this location are also trusted' if your database references other files within nested folders, then click 'OK'.

4
Verify Macro Settings

Navigate to 'Macro Settings' in the left sidebar of the Trust Center dialog. Ensure the appropriate macro security level is selected, then click 'OK' and restart Microsoft Access.

Configure Trust Center and Trusted Locations
Security Best Practice: Using a Trusted Location is highly recommended over enabling all macros globally, as it restricts code execution exclusively to folders you designate.
Free Microsoft Office alternative

Looking for a Lightweight Microsoft Office Alternative?

While WPS Office does not feature a direct database application like Microsoft Access, it offers a powerful, highly compatible, and free alternative for Word, Excel, and PowerPoint. If you frequently encounter version or licensing issues with MS Office suite applications, WPS Office provides seamless document handling with robust VBA support for spreadsheets.

  1. 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
  2. 2. Install WPS Office: Run the setup file and follow the straightforward on-screen instructions to complete the installation.
  3. 3. Open Your Office Files: Launch WPS Office to immediately open, edit, and save your existing documents, spreadsheets, and presentations with high fidelity.
Highly compatible with standard Microsoft Office formats including DOCX, XLSX, and PPTX.Advanced Spreadsheet application with excellent VBA and Macro support for data automation.Completely free and lightweight, running smoothly even on older hardware.All-in-one tabbed interface allows you to view multiple document types in a single window.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access database prompt 'Macros are disabled' on a new PC?

Microsoft Access restricts event procedures and macros from running in files stored in untrusted locations to prevent malicious code execution. You can bypass this securely by moving your file to a designated Trusted Location via the Trust Center.

How do I check if my Access installation is 32-bit or 64-bit?

Open Microsoft Access, go to the 'File' tab, and click on 'Account' (or 'Help' in older versions). Click the 'About Access' button. The resulting dialog box will prominently display whether your version is 32-bit or 64-bit at the top.

Will my 32-bit Access VBA code run on 64-bit Access?

Standard VBA code usually works seamlessly. However, if your VBA code contains Windows API declarations (Declare statements), it will fail on a 64-bit installation unless you update the code by adding the 'PtrSafe' keyword and adjusting variable types (like LongPtr).