Others

Fix Microsoft Access Table Not Saving New or Edited Records

WPS Content Manager Oct 9, 2026 869 views

Question details

The user is unable to save new data or modify existing records within a Microsoft Access table or data entry form.

How to Fix a Microsoft Access Table That Won't Save Records

Product: Microsoft Access
Device & OS: not provided
Scenario: Attempting to enter new records or update existing data into a database table or through a connected data entry form.
Observed behavior: The database fails to save the changes, either by throwing a constraint/permission error or silently reverting the edits.

Before you start

Verify whether this problem occurs only when using a specific data entry form or if it also happens when entering data directly into the table's Datasheet view. Take note of any specific error messages that pop up.

Solution 1Recommended

Verify Database and Folder Permissions

Ensure that your database file isn't set to read-only and that your Windows account has full read/write permissions for the folder storing the database.

Microsoft Access requires the ability to create temporary lock files (.laccdb or .ldb) in the same directory as the database. If you only have read permissions for the folder, Access will open the database in Read-Only mode, preventing any new records from being saved.

Check file properties

Navigate to the folder containing your Access database. Right-click the database file and select Properties. Ensure the 'Read-only' checkbox is unchecked.

Check folder permissions

Right-click the folder containing the database, select Properties, and go to the Security tab. Select your user account and verify that 'Full control' or 'Modify' is checked.

Restart Access

Close Microsoft Access completely and reopen the database to see if the ability to save records is restored.

Network Drives: If the database is stored on a shared network drive, you may need to ask your IT administrator to grant you Write permissions for that specific directory.

Solution 2

Check Validation Rules, Required Fields, and Primary Keys

Data will not save if the entered information violates the structural rules designed into the table, such as missing required fields or duplicating a primary key.

Solution 3

Resolve Form Property Settings and Record Locks

If you are unable to save records via a form, the form's properties might be restricting data entry, or another user might be locking the record.

Free Microsoft Office alternative

Looking for a Lightweight and Reliable Office Suite? Try WPS Office

While WPS Office does not include a direct alternative to Microsoft Access, it offers a powerful Spreadsheet application capable of managing extensive data lists, flat-file databases, and complex records. If you need a comprehensive, highly compatible, and free productivity suite for all your document, spreadsheet, and presentation needs, WPS Office is the perfect choice.

1. Download WPS Office: Visit the official WPS website to download the free, lightweight installer for your operating system.
2. Export your Access Data: Export your current Access tables to Excel (.xlsx) or CSV format.
3. Manage Data in WPS Spreadsheet: Open the exported file in WPS Spreadsheet and utilize Data Validation, Filters, and Pivot Tables to manage your records easily.

Manage extensive datasets, records, and tables efficiently using WPS SpreadsheetSeamless compatibility with Microsoft Excel formats (.xlsx, .xls) and CSV data exportsLightweight design ensures fast loading and smooth performance on older hardwareFamiliar user interface makes transitioning from Microsoft Office effortless

microsoft office alternative - wps office

Frequently Asked Questions

Why do I get a 'Write Conflict' error in Microsoft Access?

A Write Conflict error typically occurs when two users attempt to edit the exact same record at the same time in a shared database. It can also happen in a standalone database if a form and a background VBA process attempt to modify the same record simultaneously.

How can I tell if my Access database is read-only?

If your database is read-only, you will usually see the phrase '(Read-Only)' displayed next to the database name in the Access application title bar. You will also notice that you cannot add new tables, and the 'New Record' button at the bottom of your tables will be grayed out.

Can missing primary keys prevent linked tables from saving records?

Yes. If your Access database is using linked tables from an external source (such as SQL Server via ODBC), Microsoft Access requires the linked table to have a defined Primary Key. Without it, Access treats the linked table as read-only and will not allow you to save new or edited records.

Office Quick Solutions