Fix VBA Editor Unavailable in Access After Office Repair
Question details
The VBA Editor cannot be accessed in an Access front-end application, and an error requests rerunning a specific custom setup program.

- 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.
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.
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.
Ensure that Microsoft Access and the affected front-end application are completely closed.
Open the Windows Start menu, type 'Access', and locate the Microsoft Access application in the search results.
Right-click on the Access shortcut and select 'Run as administrator' from the context menu.
Open your front-end application from within this elevated Access window and attempt to open the VBA Editor.

Rerun the Front-End Application Setup
The error message specifically requests rerunning the custom setup program to restore broken dependencies.
Perform an Online Repair of Microsoft Office
Since the problem started after a previous repair attempt, a deeper 'Online Repair' might be needed to fix corrupted VBA or Access components.
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. Download the Installer: Visit the official WPS Office website and click the free download button.
- 2. Install WPS Office: Run the downloaded executable file and follow the simple on-screen instructions.
- 3. Open Your Documents: Launch WPS Office to instantly open, edit, and save your existing Office documents.

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.




