Fix Microsoft Access 'This Object Is Locked' Error When Closing Forms
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.

- 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 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.
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.
Open Microsoft Access, go to the Create tab, and select Blank Report.
Add your desired graph (ActiveX or Modern Chart) into this new, standalone report and configure its data source.
Save this new report with a descriptive name (e.g., 'rpt_EmbeddedGraph') and close it.
Right-click your main form or report in the Navigation Pane and select Design View.
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.

Verify and Update the Graph Control Type
Check if your database relies on older ActiveX controls, which are more susceptible to locking and rendering issues, and upgrade to Modern Charts if possible.
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. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open your data file: Launch WPS Spreadsheet and open your existing data files directly.
- 3. Insert beautiful charts: Navigate to the Insert tab, select Chart, and easily visualize your data without worrying about database object locks.

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.




