How to Fix Access Event Procedures Failing on Another Computer
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.

- 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.
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.
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.
Launch Microsoft Access on the affected computer. Go to 'File' > 'Options' > 'Trust Center', and then click the 'Trust Center Settings' button.
Select 'Trusted Locations' from the left sidebar and click 'Add new location'. Browse to the folder where your copied ACCDB file is stored.
Check the box that says 'Subfolders of this location are also trusted' if your database references other files within nested folders, then click 'OK'.
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.

Resolve Missing VBA Library References
If event procedures still fail, the new computer might be missing specific DLLs or library references that the original database relied upon.
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. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the setup file and follow the straightforward on-screen instructions to complete the installation.
- 3. Open Your Office Files: Launch WPS Office to immediately open, edit, and save your existing documents, spreadsheets, and presentations with high fidelity.

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).




