Others

Fix Microsoft Access 'This Object Is Locked' Error When Closing Forms

John WilsonJohn Wilson Nov 3, 2026 870 views

Question details

The user is experiencing an issue where closing an Access report or form containing graphs triggers a warning that the object is locked, resulting in any changes being discarded.

How to Fix 'This Object Is Locked' Error in Microsoft Access
Product
Microsoft Access
Device & OS
not provided
Scenario
Attempting to close an Access report or form that contains embedded graph controls after making modifications.
Observed behavior
Access displays a message stating 'This object is locked' and discards all changes made to the form or report upon closing.
Before you start

Before making structural changes to your database, check the property sheet of your current graph to determine whether it uses an older ActiveX control or the newer Modern Charts feature.

Solution 1Recommended

Create and Embed a Separate Graph Object

Isolating the graph into its own separate report object and embedding it prevents direct modification conflicts on the main form, avoiding the locked-object warning.

When graphs are built directly into a main form or report, Access may struggle to process the design changes alongside the graph data, leading to a locked state. Embedding the graph as a subreport bypasses this conflict.

1
Create a new report

Open Microsoft Access, go to the Create tab, and select Blank Report.

2
Insert the graph

Add your desired graph (ActiveX or Modern Chart) into this new, standalone report and configure its data source.

3
Save the standalone graph

Save this new report with a descriptive name (e.g., 'rpt_EmbeddedGraph') and close it.

4
Open the main form or report

Right-click your main form or report in the Navigation Pane and select Design View.

5
Embed the graph object

Drag and drop the newly created graph report from the Navigation Pane onto your main form to embed it as a subform/subreport control. Save your changes.

Create and Embed a Separate Graph Object
Conflict Resolved: By placing the graph inside a subreport, you no longer modify the embedded graph control directly from the main form, ensuring your design changes save successfully without triggering the lock error.
Free Microsoft Office alternative

Try WPS Office for Hassle-Free Data Visualization

While Microsoft Access is designed for complex relational databases, creating simple charts and graphs shouldn't involve locking errors. WPS Spreadsheet provides a robust, lightweight, and completely free alternative for data analysis and visualization without the complicated design view conflicts.

  1. 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
  2. 2. Open your data file: Launch WPS Spreadsheet and open your existing data files directly.
  3. 3. Insert beautiful charts: Navigate to the Insert tab, select Chart, and easily visualize your data without worrying about database object locks.
Fully compatible with Microsoft Excel (.xls, .xlsx) files for seamless data transitionRich built-in chart types for powerful, conflict-free data visualizationFree, lightweight suite that consumes minimal system resourcesFamiliar interface ensures a zero learning curve for Microsoft Office users
microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Access lock objects when closing a form?

Access locks database objects to prevent conflicting data modifications or corruption. If a graph or an embedded control is being actively processed, calculated, or hasn't released its memory thread in the background, Access prevents you from saving changes to the parent form to protect the database integrity.

What is the difference between ActiveX and Modern Charts in Access?

ActiveX charts rely on older OLE (Object Linking and Embedding) technology and the legacy Microsoft Graph component, which can cause performance issues and locking errors. Modern Charts, introduced in newer versions of Access, are native controls that offer better responsiveness, modern aesthetics, and improved stability.

Can I recover the discarded design changes after the lock warning appears?

Unfortunately, once Access forces you to discard the changes upon closing the form, those unsaved design modifications cannot be recovered. To prevent data loss, it is highly recommended to save your work frequently (Ctrl + S) while operating in Design View.