How to Fix Access ACCDE Not Updating Main ACCDB
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.

- 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.
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.
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.
Launch Microsoft Access and open your original, unified ACCDB database file that contains all your tables, forms, and queries.
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.
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.
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.
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.

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.

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.




