File Sharing Problems

How to Share an Updated Microsoft Access Form with Users

Jason MillerJason Miller Nov 22, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Split the database if needed

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.

2
Check the linked tables

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.

3
Update and test the form

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.

4
Replace users' front ends

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.

Keep the back end in place: Replace only the front-end files when distributing the form update. Users need appropriate permissions on the shared folder and must be able to reach the linked back-end file.
Free Microsoft Office alternative

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.

Organize and share tabular data in WPS SpreadsheetsWork with Microsoft Excel XLSX and XLS filesOpen and edit Microsoft Word and PowerPoint formatsUse a familiar interface for common office tasks
microsoft office alternative - wps office

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.