Exclusive Access - How is it set?

[ExcelMan]

I have an ADP with multiple users. Right now the ADP resides on the
same physical server as SQL Server and each user has a desktop
shortcut to the ADP on the server. This is all on a LAN and
performance is just fine even when many users are on simultaneously.

The problem I have is that one of the users seems to have exclusive
rights. When he opens the ADP first, no one else can get open the
ADP. If someone else gets on first, everyone can get on, including
the first user.

Obviously this first user has exclusive rights that are blocking the
other users when he gets on first. I am not sure how that occurred.
Where do you set a users rights that granted him exclusive access to
the ADP? Does this have anything to do with his SQL Server
permissions?

Thanks.

P.S. I understand from other posts on this board that using a common
ADP is not recommended and each user should get their own copy.
However, this creates a maintenance headache. Every time the ADP is
changed the changes need to be propogated out to each user's machine.
I understand a batch file may be available to download a new version
if the user's is out of date. Does anyone have an example of such a
file?

Thanks again.

 

[Sylvain Lafontaine]

Each user should have its own copy of the ADP file. This is not only a
question of access rights but if there is ever a big difference of library
versions between two users because of a difference of Windows versions, SP
and/or hotfixes or if there is network problem, you could end up with a
corrupted ADP project.

In your case, this is a typical problem when many users are sharing the same
ADP project file. I don't know what the solution is because I never had
this problem (because my clients don't share the same project file) but the
first thing to would be probably to check the shortcut and check the
permissions on the server directory.

Chances are low that this has something to do with the SQL-Server itself.

 

[aaron.kempf]

with ADP; you can keep 20 copies of the same file-- in a network
share.

With Access MDB; you have to move everything to the desktop.

Writing a batch file to take one file and copy it 20 times shouldn't
take you 60 seconds

-Aaron

 

[user]

(e-mail address removed) escribió:

with ADP; you can keep 20 copies of the same file-- in a network
share.

With Access MDB; you have to move everything to the desktop.

Writing a batch file to take one file and copy it 20 times shouldn't
take you 60 seconds

-Aaron

 

[Pete D.]

Try this for your frontend updates

http://www.granite.ab.ca/access/AutoFE.htm