'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Add Separate Open With Options for Access 2003 and 2021
Question details
The user wants to distinguish and choose between Microsoft Access 2003 and Access 2021 in the Windows 'Open With' menu for MDB files.
- Product
- Microsoft Access
- Device & OS
- Windows
- Scenario
- Opening MDB files on a system with multiple versions of Microsoft Access installed.
- Observed behavior
- Windows displays both software versions simply as 'Microsoft Access' in the context menu, making it difficult to select a specific version to launch.
Before modifying the Windows menu, locate the exact file paths for both MSACCESS.EXE files on your hard drive, which are typically found in 'C:\Program Files' or 'C:\Program Files (x86)' under their respective Microsoft Office version folders.
Manually Browse to the Specific Access Executable
Use the Windows 'Open with' dialog to browse your hard drive and manually select the exact executable file for the version you want to use.
Because Windows registers file associations by the executable name, both versions appear identical in the default list. Browsing directly to the application path ensures you are launching the correct version.
Right-click the MDB file you want to open, hover over 'Open with', and select 'Choose another app'.
Scroll to the bottom of the app list, click 'More apps', scroll down again, and select 'Look for another app on this PC'.
Navigate to the installation folder for your desired version (for example, Access 2003 is often in 'C:\Program Files (x86)\Microsoft Office\OFFICE11'). Select 'MSACCESS.EXE' and click 'Open'.
Create Dedicated Desktop Shortcuts
Create distinct shortcuts on your desktop for Access 2003 and Access 2021 to bypass the Open With menu entirely.
Add Custom Context Menu Commands via Registry Editor
Advanced users can add permanent right-click menu options for each Access version by modifying the Windows Registry.
Switch to WPS Office for a Lightweight Document Experience
While Microsoft Access is required for specific database (MDB) management tasks, you can avoid Office version conflicts for your everyday documents by using WPS Office. It provides a highly compatible, free, and lightweight alternative for your Word, Excel, and PowerPoint needs.
- 1. Download WPS Office: Visit the official WPS website and click the free download button.
- 2. Install the Application: Run the downloaded installer and follow the on-screen instructions to set up WPS Office on your computer.
- 3. Open Your Documents: Launch WPS Office to easily manage and edit your Word, Excel, PowerPoint, and PDF files with full compatibility.
Frequently Asked Questions
Why do both Access versions show up with the exact same name in the Open With menu?
Windows reads the application's internal metadata and the executable file name to populate the Open With menu. Because both Access 2003 and Access 2021 use the exact same file name ('MSACCESS.EXE') and internal branding, Windows lists them identically as 'Microsoft Access'.
Can I run Access 2003 and Access 2021 on the same computer simultaneously?
Yes, it is possible to install multiple versions of Office on the same PC. However, Microsoft recommends installing them in chronological order. Be aware that opening both at the exact same time, or switching frequently, might trigger an Office configuration or repair prompt.
How can I set Access 2021 as the permanent default for all MDB files?
Right-click any MDB file, select 'Open with' > 'Choose another app', locate the Access 2021 version using the 'Look for another app on this PC' option, and check the box that says 'Always use this app to open .mdb files' before clicking Open.
Will uninstalling one version of Access delete or corrupt my MDB files?
No, uninstalling Microsoft Access only removes the program files. Your personal MDB database files remain completely intact. However, you may need to run a quick repair on your remaining Office version to restore default file associations.
