How to Fix Access Table Missing When Opened with Access Runtime
Question details
Users are unable to see their database tables when opening a Microsoft Access file using the Access Runtime environment.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A user or colleague is trying to open a shared database file but cannot access the underlying data tables or navigation pane.
- Observed behavior
- The tables appear to be entirely missing from the interface, and the application typically displays 'Powered by' text in the lower-right corner, indicating it is running in Runtime mode.
Verify whether the affected computer has the full version of Microsoft Access installed, or if it only has the Access Runtime version installed.
Verify File Extensions and Shortcut Switches
Ensure the database file is not intentionally forced to open in Runtime mode using specific extensions or command-line switches.
Certain file extensions and launch parameters instruct Windows to simulate the Runtime environment even if the full version of Access is installed.
Right-click the database file and select 'Properties'. If the file extension is '.accdr', the file is locked to Runtime mode. Rename the file extension to '.accdb' to allow it to open normally in full Access.
If you are launching the database from a desktop shortcut, right-click the shortcut and select 'Properties'. Look at the 'Target' field. If you see a '/runtime' switch at the end of the file path, delete that switch and click 'Apply'.
Change Default App Settings or Open Manually
If both full Access and Access Runtime are installed, Windows may be defaulting to the Runtime version when you double-click a file.
Need a seamless office suite? Try WPS Office
While WPS Office does not handle Microsoft Access database files, it is a highly compatible, free, and lightweight alternative for your Word, Excel, and PowerPoint documents. Experience a familiar interface and seamless migration for your daily productivity needs.
- 1. Download the installer: Visit the official WPS Office website and click the Free Download button for your operating system.
- 2. Install the software: Run the downloaded installer and follow the simple on-screen instructions to complete the setup.
- 3. Open your documents: Launch WPS Office and open your existing Word, Excel, or PowerPoint files without losing any formatting.
Frequently Asked Questions
What is Microsoft Access Runtime?
Access Runtime is a free distributable version of Microsoft Access that allows users to run desktop database applications without needing to purchase or install the full version of Access. However, it hides design-related features like the navigation pane, built-in toolbars, and raw data tables.
Can I edit or view tables directly in Access Runtime?
No, Access Runtime is designed exclusively for executing pre-built applications. You cannot create, modify, or view the raw design of tables, queries, or forms unless the database developer explicitly programmed a way to view them into the application's user interface.
How can I tell if I am using Access Runtime instead of full Access?
When a database is opened in Runtime mode, you will typically see 'Powered by' text in the lower-right corner of the window. Additionally, the standard ribbon menus will be missing, and the left-side navigation pane will be completely unavailable.
