Discussion Locked

Access Not Open for Exclusive Use Messsa

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Running MS Office 2000, SR1-A, installed locally. If user tries to open database on (Novell) network drive via an icon and tries to modify a report he is told that Access is Not Open for Exclusive Use. Have confirmed that he is only one using the database. Message not received if database copied to local drive OR if file is opened from the Access File -> Open menu.

Is this just a bug or is there a fix!

5 replies

by donq

The database owner (or user who created the database) is the only individual authorized to open the database exclusively (by defauly)

If you are attempting to modify the design the database may need to be opened exclusively?? Have the database owner authorize the user having the problem exclusive rights permission via: (main menu) Tools | User and Group Permissions - select the user in question and select "database" from the Object Type combo and grant him/her the Open Exclusive permission.

Novel doesn't have anything to do with your problem since Access 2000 can be both a client and/or server and when it's running on a network it must be opened exclusively to allow many changes. Hope this helps.

by dbrozier

Are you asking "How do I open Access in exclusive mode ? " or " How do I set options to open in shared mode or exclusive mode?"
You can set Access to open in Exclusive mode or shared mode by going to the Tools-Options-Advanced and picking Default open mode.

This discussion is closed to new replies.