How to Share an Updated Microsoft Access Form with Users
Question details
The administrator needs to distribute an updated Access form without interrupting access to shared back-end data.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Users need an updated form while continuing to work with shared database tables.
- Observed behavior
- Each user should receive the updated form and continue accessing the shared back-end data.
Check whether the database is already split and confirm that users can access the shared back-end folder. Users also need Microsoft Access or a compatible Access Runtime to open the front end.
Distribute an Updated Access Front End
Use a split database to update forms locally while keeping the tables in a shared back-end file.
A split database stores tables in a shared back end and keeps forms, queries, reports, and code in a separate front end. Each user works from a local copy of the front end.
In Access, open the database and select Database Tools > Access Database. Follow the Database Splitter wizard to create a back-end file, then place it in a shared network folder.
Open the front end and use External Data > Linked Table Manager to verify or update its links to the shared back-end file. Use a network path that all users can access.
Open the form in Design View in your front-end copy, make the changes, and save it. Open the form in Form View and test it against the shared tables.
Ask users to close their front-end files, then provide the updated front-end file for each user to copy to their local computer and open. Alternatively, use an automatic front-end updater to deploy replacement copies.
Use WPS Office for Shared Spreadsheet Work
WPS Office is a free, lightweight alternative for everyday document and spreadsheet work, with a familiar interface and Microsoft Office format support for easier migration. It does not replace Microsoft Access or update Access database forms.

Frequently Asked Questions
Do users need a separate copy of the Access front end?
For a split database, give each user a local front-end copy containing the forms, queries, reports, and code. The linked tables remain in the shared back-end file.
Will replacing the front end delete the shared data?
Replacing the front end does not replace the shared back-end tables. Verify that the updated front end links to the correct back-end file before distributing it.
What if the updated front end cannot find the tables?
In Access, open External Data > Linked Table Manager and update the links to the shared back-end file. Also check that the user can access the network folder.
Can users open the updated form without the full version of Access?
Users can use a compatible Microsoft Access Runtime to open an appropriately configured front end, although Runtime does not provide the full Access design environment.




