How to Fix Microsoft Access Opening in Runtime Mode Without Design Tools
Question details
The user's Microsoft Access application lacks design tools and database development features because it is opening in Runtime mode.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Attempting to create, modify, or develop a database application using Microsoft Access.
- Observed behavior
- Microsoft Access opens as the Runtime version, which successfully opens existing applications but hides all ribbon commands and design tools necessary for editing.
Ensure you have your Microsoft 365 account credentials ready, as you will need to check your current subscription plan and assigned licenses in the account dashboard.
Verify Your Microsoft 365 License Type
Check your Microsoft account portal to determine if your current subscription actually includes the full desktop version of Microsoft Access.
Some Microsoft 365 editions do not include the full Access desktop application. If your plan lacks it, your system may default to the free Runtime version, restricting your ability to edit databases.
Navigate to the official Microsoft 365 login page and sign in with the account associated with your Office installation.
Click on 'My account' and navigate to the 'Subscriptions' or 'Apps & devices' section to view your active licenses.
Look through the list of included applications. If Access is missing, you must purchase a standalone license or upgrade to a business plan that includes it.
Request Full Access License from IT Administrator
If you are using a work or school computer, your IT administrator may have only deployed the Runtime version.
Need a Lightweight Office Suite for Your Documents?
While Microsoft Access handles complex databases, you might also need an efficient, cost-effective solution for your daily document, spreadsheet, and presentation tasks. WPS Office is a highly compatible, free alternative to Microsoft Office.
- 1. Download the installer: Visit the official WPS website and click the free download button for your operating system.
- 2. Install the software: Run the downloaded installation file and follow the on-screen prompts to complete the setup.
- 3. Start creating documents: Open WPS Office and instantly create or edit your existing Word, Excel, or PowerPoint files without formatting issues.
Frequently Asked Questions
What is the difference between Microsoft Access and Access Runtime?
The full version of Microsoft Access includes comprehensive design tools, ribbon commands, and development features for creating and modifying databases. Access Runtime is a free application that only allows users to run and interact with existing databases without the ability to alter their design.
Is Microsoft Access included in all Microsoft 365 subscriptions?
No, Microsoft Access is only included in specific plans, such as Microsoft 365 Personal, Family, and higher-tier Business or Enterprise subscriptions. It is also strictly a PC-only application and is not available for Mac.
How can I launch an existing database using Access Runtime?
If you deliberately want to test how your database behaves in Runtime mode, you can launch it via the command line or a desktop shortcut by adding the runtime switch, such as: msaccess.exe /runtime "C:\Path\To\YourDatabase.accde".
Can I unlock design tools within the Runtime application?
No, there is no setting or product key that unlocks design tools directly within the Runtime installation. You must uninstall Access Runtime and install the full version of Microsoft Access.
