Chapter 11, “Developing an MDB Client/Server Application with Linked Tables,” showed you how to properly build an application involving linked tables. As discussed in this chapter, the other alternative is to use an Access Project to solve the problem. Once again, the application will be built around the NorthWind client/server database.
To build the ADP file:
Click File, New.
Select Project (Existing Data).
Select a name and location for the Access Project (.adp). Click Create. The Data Link Properties dialog box appears.
In the Select or Enter a Server Name text box, enter the name of the server where the NorthWind database resides.
Specify how you will log on to the server.
Select the NorthWind database ...