Fix Microsoft Access Query Design View Not Allowing Editing
Question details
The user is unable to edit within Microsoft Access Query Design View, experiencing a prohibited cursor when attempting to drag fields into the view.

- Product
- Microsoft Access 365
- Device & OS
- Windows 11
- Scenario
- Dragging fields into Query Design view to modify or create a database query.
- Observed behavior
- The pointer changes to a prohibited cursor, existing tables cannot be removed, and restarting or reinstalling Access fails to provide a permanent fix.
Ensure your database file is not stored in a read-only folder and that you have full administrative permissions to modify the file.
Bypass AutoExec Macros on Startup
Use the Shift key during database launch to prevent startup macros from disabling design changes.
Microsoft Access allows developers to create an AutoExec macro that runs automatically when a database opens. This macro can sometimes lock the interface or disable the Query Design view to protect the database structure.
Ensure that Microsoft Access and the problematic database file are completely closed.
Press and hold down the 'Shift' key on your keyboard.
While still holding the 'Shift' key, double-click your database file to open it. Keep holding the key until the database is fully loaded.
Navigate to the Query Design view and try dragging fields to see if the prohibited cursor issue is resolved.

Verify File Permissions and Read-Only Status
Ensure Windows folder permissions are not restricting Microsoft Access from modifying the database file.
Disable Conflicting Access Add-ins
Turn off third-party add-ins that might be interfering with the Microsoft Access workspace.
A Lightweight and Free Alternative for Your Office Needs
If you are experiencing complex configuration issues and restricted interfaces in Microsoft Office, consider trying WPS Office. While it does not offer a direct database equivalent to Access, it provides a seamless, highly compatible, and lightweight suite for all your document, spreadsheet, and presentation needs without hefty subscription fees.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package.
- 2. Install the Software: Run the downloaded executable file and follow the straightforward on-screen instructions.
- 3. Open Your Files: Launch WPS Office and directly open your existing Microsoft Office documents and spreadsheets without format loss.

Frequently Asked Questions
Why does my cursor turn into a prohibited symbol in Access Query Design View?
This typically occurs when a database's AutoExec macro or startup VBA code has disabled design changes to protect the database structure. It can also happen if the file is locked in read-only mode by Windows.
What is an AutoExec macro in Microsoft Access?
An AutoExec macro is a special script designed to run automatically as soon as a database is opened. Database administrators use it to configure startup settings, hide the navigation pane, or apply security restrictions.
How can I permanently fix the Query Design view if the Shift key bypass works?
Once you bypass the startup scripts using the Shift key, you need to navigate to your macros, locate the 'AutoExec' macro, open it in Design View, and modify or remove the actions that are locking the design interface.




