Others

How to Fix Microsoft Access Not Saving Form Design Changes

WPS Editor Oct 9, 2026 871 views

Question details

Users are unable to save design changes made to a main menu form in Microsoft Access, even after clicking 'Yes' when prompted to save.

How to Fix Microsoft Access Not Saving Form Design Changes

Product: Microsoft Access 2016
Device & OS: not provided
Scenario: Editing form design elements, such as button events, in a database stored on a shared network drive.
Observed behavior: Modifications to the form disappear immediately after closing and reopening the database, despite the user confirming the prompt to save the design changes.

Before you start

Ensure that no other users currently have the database open on the network, and create a complete backup copy of your ACCDB file before modifying database architecture.

Solution 1Recommended

Implement a Properly Split Database Architecture

The most reliable way to prevent lost design changes is to split the database and keep the application front-end on your local machine.

Editing forms directly from a shared network copy often leads to saving failures and file corruption. A professional Access application separates data (tables) from application objects (forms, reports, and code).

Split the database

Move all data tables into a back-end ACCDB file stored securely on the shared network drive.

Create the front-end file

Keep all forms, queries, reports, and VBA code in a separate front-end ACCDB file.

Copy to local machine

Copy the front-end file from the network to your local computer's hard drive.

Edit locally

Open the local front-end file, make your form design and button event changes, and save.

Distribute updates

Distribute the updated front-end copy to replace the older local copies on all other users' computers.

Implement a Properly Split Database Architecture

Best Practice: Even if only one person uses the database at a time, keeping a local front-end prevents network interruption issues when saving structural designs.

Solution 2

Verify Network Folder Permissions

A lack of adequate write permissions on the network drive can prevent Access from committing design modifications to the file.

Solution 3

Run Compact and Repair

Database bloat or minor corruption can cause hidden saving glitches, which are often resolved by the built-in Compact and Repair utility.

Free Microsoft Office alternative

Try WPS Office for Your Document and Data Management Needs

While Microsoft Access handles complex relational databases, for standard office tasks, data processing, and document editing, WPS Office provides a lightweight and free alternative to Microsoft Office. Enjoy a familiar interface and seamless migration without the heavy subscription costs.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
2. Export Access data: Export your Microsoft Access tables to Excel format (.xlsx) for easier sharing and analysis.
3. Open in WPS Spreadsheet: Launch WPS Spreadsheet and open your exported data to utilize advanced formulas, pivot tables, and charts.

Free to use with a lightweight and fast installation packageHighly compatible with Microsoft Excel, Word, and PowerPoint formatsFamiliar, tabbed user interface for easy multi-tasking across documentsBuilt-in PDF editing, conversion, and annotation tools

microsoft office alternative - wps office

Frequently Asked Questions

Why does Access prompt me to save changes but doesn't actually save them?

This usually happens when editing a database over a shared network drive where another user has a lock on the file, or if you lack sufficient write permissions in the network directory.

What is a split Access database?

A split database separates the application into two distinct files: a back-end containing only the data tables, and a front-end containing the user interface elements like forms, queries, and reports.

How do I update forms for other users in a split database?

You should make all form and design changes on your local front-end copy. Once tested and saved, distribute the updated front-end file to replace the older local copies on all users' computers.

Does compact and repair delete my data?

No, the Compact and Repair tool reorganizes the file to reclaim unused space and fixes minor structural corruptions without deleting your actual records or data.

Office Quick Solutions