Database Locking up

[Martin]

I am fairly new to Access database programming and so far
have been doing ok except for an issue which has seemed to
be a total mystery to me. It has to do with users being
unable to launch databases on my department's server when
I or one of my colleagues have it open (even non-
exclusively).

The external users normally have READ only access to our
databases since they just do lookups and searches on the
tables. Our department has full access. What we've
noticed is that whenever one of us has one of the
databases open, others will not be able to get in. They
get the message ... "The Microsoft Jet database ebgine
cannot database open the file "database name.mdb". It is
already opened exclusively by another user, or you need
permission to view its data."

We are using Access 97 logging on to our network on NT
Clients and our servers are Windows 2000. We don't have
any Access security setup because our scheme is pretty
simple. I have administrative rights to our server so
users that don't normally have access can be given access.

PLEASE ADVISE IF ANYONE CAN SHARE SOME THOUGHTS/IDEAS
ABOUT THIS PROBLEM. THANKS IN ADVANCE.

 

[Joan Wild]

Double check the permissions on the folder and the file. Users need full
permissions on the folder (even if they only read data). Without the full
permissions, the users are unable to create the associated ldb file, and as
such the mdb is opened exclusively.

 

[Martin]

Joan,

I appreciate the response. I think you may have answered
my question. I am only granting READ-only access to the
folder level. I will tweak the settings according to your
suggestions and give that another try.

Thanks a bunch.


Martin

 

[Mike]

After they have full access to the folder, use the Access
security wizard and create user access permissions. That
is the best thing to do. Simple too.