Link to home
Start Free TrialLog in
Avatar of InvisibleMan
InvisibleMan

asked on

EXCLUSIVE LOCK ON ACCESS 2000 DB - Locked by Admin etc.

Hello all.  I am having trouble with an Access 2000 database in which the database resides on a network drive.  When 2 users try to open the database it says it is either locked by such and such user or admin has it locked.  The database is set to shared and not exclusive.  Any ideas how I can resolve this without having to copy down local copies?  Thanks all
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Make sure the users have full read/write/delete priviledges for the directory where the MDB resides.  If they don't, Access cannot create a LDB file to help in tracking locks and will open the MDB in exclusive mode.

Jim.
Avatar of ColinGlenister
ColinGlenister

Have you secured the database? (Created a Workgroup file).

If not each of your users are opening the database with Admin permissions and some update actions will cause the database to be locked exclusvely.

You may also need to split the database.

Let me know how the db is accessed by the Users.

Colin Glenister
I seem to remember hearing about a bug in A2K (yes really!) That it only opened in exclusive mode if it was opened using a shortcut. The solution is to open A2K first then use "File", "Open Database", etc, etc.

Hope this helps
InvisibleMan please either:

1. Award the question to an expert
2. Request points refunded for no answer

Do not accept this comment as an answer!

Lunchy
Friendly Neighbourhood Community Support Moderator