How to Edit Tables in a Microsoft Access Split Database Back End
Question details
The user needs to add fields to tables in a shared Microsoft Access split database and determine which database file to edit.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- The database stores its tables in a back-end file on a shared server, while multiple users work through separate front-end files.
- Observed behavior
- While importing objects, the user received a “Record is deleted” message and a “Name AutoCorrect Save Failures” table. The user later identified that objects had been imported into the front end instead of the back end.
Confirm the location of the shared back-end file by checking a linked table in the front end through External Data > Linked Table Manager. Arrange a maintenance window and ask all users to close their front-end databases before changing table structure.
Open the back-end database directly to add or change fields
Use this method to edit the actual tables without rejoining and splitting the database again.
In a split database, the back end contains the actual data tables, while the front ends contain links to those tables and typically hold forms, queries, and reports. Make table-structure changes in the back-end file rather than importing the tables into a front end.
Ask every user to exit their front-end database. Close your own front end as well so linked tables are not in use during the structural changes.
In Microsoft Access, select File > Open > Browse and select the back-end database on the shared server. If exclusive access is needed, use the arrow beside the Open button and choose Open Exclusive; this requires other users to have closed the database.
In the back-end database's Navigation Pane, right-click the table and select Design View. Add the required field names and data types, or modify the appropriate field properties.
Press Ctrl+S to save the table changes, then close the back-end database before reopening a front end for testing.
Refresh front-end links and update objects that use the changed table
Use this after saving the back-end changes, particularly if a front end cannot see the updated table or its links need reconnecting.
Use WPS Office for Documents and Spreadsheets Alongside Access
WPS Office is a free, lightweight option for everyday documents, spreadsheets, and presentations, with a familiar interface and Microsoft Office format compatibility for easy migration. It does not edit Access back-end databases or repair linked tables; keep using Microsoft Access for those tasks.

Frequently Asked Questions
Do I have to rejoin an Access split database before adding fields?
No. Open the back-end database directly, right-click the actual table in the Navigation Pane, and select Design View. Add the fields there while no users are accessing the table.
Can users keep their front ends open while I change the table structure?
Schedule the change when all users can close their front ends. Structural edits require appropriate access to the table, and active connections can prevent Access from obtaining the necessary lock.
Why does a new field not appear on an existing form?
Adding a field to the back-end table does not automatically add a control to a form. Open the form in Design View, check its Record Source, and add a control for the new field. If the source query lists specific fields, update that query first.
Does the “Name AutoCorrect Save Failures” table mean I need to split the database again?
No. That table records failures related to Access Name AutoCorrect and does not, by itself, show that the database must be rejoined or split again. In this case, first verify that you are editing or importing into the intended back-end file. If errors continue, inspect the failure entries before making further changes.
Can WPS Office open and edit an Access back-end database?
WPS Office does not provide an Access database editor for ACCDB or MDB files. Use Microsoft Access to modify the back end. For spreadsheet analysis, export a table or query from Access through External Data > Export > Text File and open the resulting CSV in WPS Spreadsheet.




