Microsoft Office Tutorials and References
In Depth Information
Splitting Your Database into a Front End and a Back End
The Navigation Pane lists every object in an Access database, but having to
click and scroll around the list to find the forms and reports that you use
most can be annoying. Wouldn’t it be nice to have a list of just the objects
you usually use? Better yet, if several people use the database, each person
might like to have a list of favorite objects in daily use. You can create a
group on the Navigation Pane for each user; see Book I, Chapter 2 for
Relinking your tables
The links between the front-end and back-end databases work only as long
as the files are in the same positions relative to each other. If you create the
back-end database in the same folder as the original database, the two
databases need to be in the same folder to work. If you need to move one of the
files, you have to relink the tables. (You may decide to move the back-end
database to a network drive where you can share it with other users on a
LAN and give copies of the front-end to people in your office.)
To relink tables, follow these steps:
1. Put the front-end and back-end databases in their new locations.
The two databases need to be in their new positions to ensure that
2. Open the front-end database, and view the list of tables in the
Now you’re ready to relink the tables.
3. Do one of the following:
option from the contextual menu.
the External Data tab of the Ribbon.
The Linked Table Manager opens, showing a list of your linked tables
along with the name of the database that each table links to. (Not all
linked tables have to link to the same database!)
4. Click the Select All button, check the Always Prompt for New Location
box, and then click OK.
The Select New Location Of dialog box appears.
5. Navigate to the folder in which you put the back-end database, and
click its icon.
6. Click the Open button in the Select New Location Of dialog box.
The Linked Table Manager displays a dialog box saying that all selected
linked tables were successfully refreshed.