Exclusive Access

[Peter Marshall]

I have an ADP Access frontend (to a SQL backend) that only seems to allow 1
user in at a time for the purposes of adding or editing queries, reports,
etc. In an Access MDB I know that under Tools-Options-Advanced, I can
specify Default Open Mode (shared or exclusive), but I don't have that
option in the ADP. Is there anyway to allow multiple users in to create
queries and reports?

 

[Norman Yuan]

Since Access2000 (maybe 2002), only one user can open Access in design mode
to design Form/Report (front end object). Query in ADP is backend objects,
such as View/SP/UDF. Whether a user is allowed to create backend objects is
determined by SQL Server security.

With that said, if there is need to allow more than one user to design forms
and reports in ADP, the usewr should have his own copy of ADP. It is
impossible to have two users to do form/report design iin the same copy of
ADP file at the same time.

 

[Sylvain Lafontaine]

Sory but ADP doesn't support any form of multi-user designing. Only the
first user who opens the project can make any change to it. Of course, you
can have each user having their own copies of the ADP project (or even using
blank projects with only a connection to the sql-server) in order to make
their own private changes and/or create their own queries and reports and
later - if you want to - you can incorporate all or some of these changes
into a master project.

Also, not only it's the only way to have multiple users making changes but
it's also the suggested way that each user should always have his or her own
copy - even if they don't intend to make any design change or create any new
query or report - because like MDB files, ADP files are compiled and are
very sensitive to any difference between the multiple versions of Windows
and Service Packs that could be find on each user's machine. I'm not sure
but I think that there is also some operations like changing dynamically a
record source or a row source property that cannot be executed by users who
have opened their projects with the read-only mode.

I never tried it but the FrontEnd AutoUpdater from Tony Toews that you can
find on the internet for MDB files should also work for ADP. You could also
use a small batch program that would copy and launch the project each time a
user click on it.