Access Lock File

J

John Bigness

I have a shared Access file on a network with 3 potential users - call them
User A, User B and User C. When User A opens the file, no one else can
access it and there is no Access Lock file that appears on the network.
Users B and C can coexist in the file simulaneously (and an Access lock file
appears) but User A cannot get in the file whenever either B or C are in it.

Is there something wrong with the Office 2000 setup on User A's PC? Or is
there a problem at the file itself? Any suggestions?
 
6

'69 Camaro

Hi, John.

User A is opening the database in exclusive mode. Ensure that User A has
the database option "Default Open Mode" set to shared, or is using a shortcut
without the /excl command-line switch, or is not opening the database from
Access with the "Open Exclusive" option in the File Open dialog window.

Also, make sure that all users have "Full Control" Windows security
permissions on the directory that contains the database file. For more
information on multiuser databases, please see the following Web page for a
link to the article "Multiuser Databases":

http://www.Access.QBuilt.com/html/articles.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.
 
A

Arvin Meyer

Also, make sure that all users have "Full Control" Windows security
permissions on the directory that contains the database file.
Click to expand...

Users do not need Full Control, nor are the likely to get it on most
networks. They need permissions to Read, Write, and Delete. The difference
being that Full Control gives the user the right to take over the file and
lock out other users.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
A

Arvin Meyer

Joseph Meehan said:
They also may need create and edit premissions.
Click to expand...

Correct on the create, edit is usually implicit with write permission. To
add something useful here: The create and delete file permissions are
required for handling the locking file (.LDB file) Without those 2, all
databases can only be opened by the 1 user.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top