VBA & Macro Problems

Fix VBA Editor Unavailable in Access After Office Repair

Huda QurayshiHuda Qurayshi Nov 3, 2026 869 views

Question details

The VBA Editor cannot be accessed in an Access front-end application, and an error requests rerunning a specific custom setup program.

How to Fix VBA Editor Unavailable in Access After Office Repair
Product
Microsoft Access
Device & OS
not provided
Scenario
Opening the VBA editor or running an Access front-end application immediately following a Microsoft Office repair.
Observed behavior
Access denies entry to VBA and displays an error message instructing the user to rerun a specific custom setup program, such as the Pancake Mill and Pie Shoppe setup program.
Before you start

Ensure you have the installation files or original setup media for both Microsoft Office and the specific front-end application, as reinstallation of these components may be necessary.

Solution 1Recommended

Run MS Access as Administrator to Check Permissions

Running the application with elevated privileges determines if the VBA issue is caused by restricted Windows user permissions.

Often, an Office repair can alter or reset folder and registry permissions. If the VBA editor opens without errors in Administrator mode, it confirms that your standard user profile lacks the necessary access rights.

1
Close the Application

Ensure that Microsoft Access and the affected front-end application are completely closed.

2
Locate MS Access

Open the Windows Start menu, type 'Access', and locate the Microsoft Access application in the search results.

3
Run as Administrator

Right-click on the Access shortcut and select 'Run as administrator' from the context menu.

4
Test the VBA Editor

Open your front-end application from within this elevated Access window and attempt to open the VBA Editor.

Run MS Access as Administrator to Check Permissions
Permission Confirmed: If the error disappears, you will need to ask your IT administrator to adjust your Windows security settings or registry permissions for the application folder.
Free Microsoft Office alternative

Looking for a Stable and Free Office Suite? Try WPS Office

While Microsoft Access issues can disrupt your database tasks, you shouldn't let Office repairs slow down your daily document work. WPS Office provides a highly compatible, lightweight, and completely free alternative for your word processing, spreadsheet, and presentation needs.

  1. 1. Download the Installer: Visit the official WPS Office website and click the free download button.
  2. 2. Install WPS Office: Run the downloaded executable file and follow the simple on-screen instructions.
  3. 3. Open Your Documents: Launch WPS Office to instantly open, edit, and save your existing Office documents.
Seamless format compatibility with Microsoft Word, Excel, and PowerPoint filesLightweight application that installs quickly and uses minimal system resourcesFamiliar tabbed user interface that requires no learning curveBuilt-in advanced PDF editing, conversion, and merging tools
microsoft office alternative - wps office

Frequently Asked Questions

Why does Access ask for a custom setup program after an Office repair?

An Office repair can sometimes reset registry keys or file associations that a customized Access front-end application relies on. When the application detects these missing links, it prompts you to run its specific setup program to restore them.

How do I know if the VBA issue is a Windows permission problem?

If you right-click the Access shortcut, select 'Run as administrator', and find that the VBA Editor opens without the setup program error, it confirms that your standard user account lacks the necessary permissions to read or write specific application files.

Does WPS Office include a database alternative to Microsoft Access?

No, WPS Office focuses on providing robust alternatives for Word, Excel, and PowerPoint, along with comprehensive PDF tools. It does not include a direct database management equivalent to MS Access, though you can export Access data to CSV or Excel formats and manage it using WPS Spreadsheets.