Others

How to Fix Access ACCDE Not Updating Main ACCDB

Kushani NimanthikaKushani Nimanthika Nov 3, 2026 868 views

Question details

The user's Access ACCDE front end is saving new records locally but failing to synchronize or update the main shared ACCDB back-end database.

How to Fix Access ACCDE Not Updating Main ACCDB Database
Product
Microsoft Access
Device & OS
not provided
Scenario
Using a compiled Access database (ACCDE) to input or edit data that should automatically reflect in a main shared database file (ACCDB).
Observed behavior
Changes made in the ACCDE file are saved within that specific compiled file only, but do not appear in the separate main ACCDB back-end database for other users.
Before you start

Ensure you have full network permissions to the shared folder hosting the back-end database and back up your original unified ACCDB file before making structural changes.

Solution 1Recommended

Split the Database and Link Tables Before Creating the ACCDE

To ensure a front end updates the shared back end, you must use a split-database design where the ACCDE contains only linked tables rather than local tables.

When an ACCDB is converted to an ACCDE, it compiles the VBA code and locks the design. However, if the tables were local in the original file, they remain local in the ACCDE. You must split the database into a front end (queries, forms, reports) and a back end (tables) and link them before compiling.

1
Open the original database

Launch Microsoft Access and open your original, unified ACCDB database file that contains all your tables, forms, and queries.

2
Run the Database Splitter

Navigate to the 'Database Tools' tab on the top ribbon. In the 'Move Data' group, click on 'Access Database' to launch the Database Splitter wizard.

3
Create the back-end database

Follow the wizard prompts to split your database. Save the new back-end file (which will contain only the tables) to a shared network location accessible by all users.

4
Verify linked tables

Check your current front-end database navigation pane. All tables should now have a small arrow icon next to them, indicating they are successfully linked to the new back-end file.

5
Compile into ACCDE

Go to 'File', click 'Save As', select 'Make ACCDE' under the Save Database As section, and click 'Save As'. Distribute this compiled ACCDE front end to your users.

Split the Database and Link Tables Before Creating the ACCDE
Distribution Tip: Give each user their own local copy of the new ACCDE front end on their machine rather than having them open a single shared front-end file.
Free Microsoft Office alternative

Looking for a fast, free alternative for your documents and data?

While WPS Office does not include a database management tool like Microsoft Access, it offers an exceptional, free alternative for Word, Excel, and PowerPoint. Enjoy a lightweight suite that effortlessly handles your daily documentation and data analysis needs.

Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx) for seamless file sharingEasily analyze and format data exported from your database using WPS Spreadsheet's advanced toolsFamiliar tabbed interface making migration simple and intuitiveLightweight installation that runs smoothly on virtually any computer
microsoft office alternative - wps office

Frequently Asked Questions

Can an ACCDE file contain local tables?

Yes, an ACCDE file can contain local tables. If tables are not moved to a back-end file and replaced with linked tables before generating the ACCDE, any data entered by the user is stored locally within that compiled file rather than the shared database.

Why do my linked tables fail to connect in the compiled ACCDE file?

This usually occurs if the back-end ACCDB file was moved, renamed, or if the user lacks network permissions to the folder where the back end is stored. Ensure the paths are correct in the original ACCDB using the Linked Table Manager before compiling.

How do I edit forms or reports once the database is in ACCDE format?

You cannot directly edit the design of forms, reports, or VBA modules in an ACCDE file. You must make all design changes in your original master front-end ACCDB file, and then generate and distribute a new ACCDE file to your users.