Office Settings & Configuration

Fix Microsoft Access Query Design View Not Allowing Editing

Natalie TaylorNatalie Taylor Nov 3, 2026 872 views

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.

Fix Microsoft Access Query Design View Not Allowing Editing
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.
Before you start

Ensure your database file is not stored in a read-only folder and that you have full administrative permissions to modify the file.

Solution 1Recommended

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.

1
Close the Database

Ensure that Microsoft Access and the problematic database file are completely closed.

2
Hold the Shift Key

Press and hold down the 'Shift' key on your keyboard.

3
Open the Database

While still holding the 'Shift' key, double-click your database file to open it. Keep holding the key until the database is fully loaded.

4
Test Query Design View

Navigate to the Query Design view and try dragging fields to see if the prohibited cursor issue is resolved.

Bypass AutoExec Macros on Startup
Permanent Fix: If this resolves the issue, you will need to open the AutoExec macro in Design View and remove the specific commands that restrict editing.
Free Microsoft Office alternative

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. 1. Download the Installer: Visit the official WPS Office website and download the free installation package.
  2. 2. Install the Software: Run the downloaded executable file and follow the straightforward on-screen instructions.
  3. 3. Open Your Files: Launch WPS Office and directly open your existing Microsoft Office documents and spreadsheets without format loss.
Avoid complex Office configuration lockouts when managing your daily data in spreadsheets.Fully compatible with Microsoft Excel, Word, and PowerPoint formats (.xlsx, .docx, .pptx).Lightweight installation with a familiar user interface requiring zero learning curve.Completely free basic version with robust built-in PDF editing tools.
microsoft office alternative - wps office

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.