Locking

[alicia]

I have searched for this topic in this newsgroup
(manually scrolling, not sure if I am even using this
newsgroup site correctly).

Can anyone provide me with resources to review to
understand the "locking" of a database and the creation
of the "lock" file when using an MSAccess. I need to
have 6 users access the database on a server and only one
person can get in at a time (I have changed the
properties of the database to allow sharing). It appears
this "Lock" file is created causing no one else to get
in. I'm new to file sharing so pardon my elementary
questions. Thanks in Advance. Alicia

 

[Immanuel Sibero]

Hi

Tell us a little more about your setup. Access version? Desktop Operating
System? Network Operating System?
Is your application split into front end and back end? Do all the users have
full rights to the folder in which the database files reside?
What file are you referring to exactly when you say "Lock" file? the LDB
file?

Users on a network have to have full access to the folder where the database
files are located. Otherwise problems such as what you describe may occur.
For example, if users do not have 'create' privilege on the folder, the
first user who gets into the database will open the database exclusively.
Other users will be left with 'readonly' access to the database.

Immanuel Sibero

 

[Chip Coutts]

Without specifics, this may be a shot in the dark...

Early on, I found that if a user had a shortcut to the
database itself (Target: "\\<server>\<database.mdb>), and
used that icon to open the database, *and* they were the
first to open the database, it would be locked for all
other users.

You may try two things. One, have your users open Access
first, then "File, Open" your database. Or, users may use
an icon on the desktop, set the Target: "C:\Program
Files\Microsoft
Office\Office\Msaccess.exe" "\\<server>\<database.mdb>".
These both do the same thing, opening Access on the local
machine first, *then* opening the database. I don't know
why this works, I only know that it fixed my problem...

Good luck!

Chip.