Access Cookbook

Share an ADP from a Shared Network Folder

Problem

You want to share an ADP on a network. However, the second user who attempts to open the ADP gets an error message.

Solution

This solution involves opening the ADP using the /runtime switch.

Follow these steps to create a shared ADP:

1. Create a shortcut on each user’s desktop. In the Properties dialog, enter information using the format shown in Figure 14-7.

   

   Figure 14-7. Properties for creating a shortcut for a shared ADP

2. Copy the shortcut to each user’s machine.

Discussion

ADPs are single-user in Access 2000 and 2002. Using the /runtime switch allows you to get around this limitation by opening the ADP as read-only.

In Access MDB databases, the Jet database engine allows multiple users to share a frontend database containing forms, reports, queries, and code, just as they can share backend databases that contain data. If necessary, the Jet engine can lock resources in the database to prevent multiple users from interfering with each other.

ADPs don’t have the benefit of the Jet database engine, so Access has no way to handle multiple users of a single project file. Users can share SQL Server data, but usually each user needs her own ADP. You can get around this by using the /runtime command-line option to force the ADP to be read-only. In this case, Access detects that there is no danger of users interfering with each other because ...