Access Cookbook, 2nd Edition [Electronic resources] نسخه متنی

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

Access Cookbook, 2nd Edition [Electronic resources] - نسخه متنی

Ken Getz; Paul Litwin; Andy Baron

نمايش فراداده ، افزودن یک نقد و بررسی
افزودن به کتابخانه شخصی
ارسال به دوستان
جستجو در متن کتاب
بیشتر
تنظیمات قلم

فونت

اندازه قلم

+ - پیش فرض

حالت نمایش

روز نیمروز شب
جستجو در لغت نامه
بیشتر
لیست موضوعات
افزودن یادداشت
افزودن یادداشت جدید










Recipe 14.3 Share an ADP from a Shared Network Folder



14.3.1 Problem


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


14.3.2 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


  1. Copy the shortcut to each user's machine.



14.3.3 Discussion


ADPs are intended for single-user
activity. 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 they can't
change anything, so it allows multiple users to work with the same
ADP.


/ 232