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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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
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
Jim.