Mutliple users over a network

  • Thread starter Thread starter idisorder
  • Start date Start date
I

idisorder

Hello,

Basically I have an access database, addresses etc. sitting on a shared
drive. The issue starts when one person has the database open, no one else
can open it.

I'm unsure whether this is a sharing issue or a database design issue.

Is there any way this can be over come,so more than one person can use
access the information?

Some details:
There isn't any need for the user to edit the data.
All users have access installed.
No password or user protection/restriction.

Any help will be gratefully received.

Thank in advance,
Gary.
 
What permissions does each user have on the folder where the MDB exists? At
a bare minimum, they need Read, Write and Execute (and should also have
Delete). That's because a locking file (.ldb) gets created by the first user
to open the database, that locking file gets updated by each subsequent
user, and gets deleted when the last user exists the database. Note that I
have heard of cases where the users have permission to create the locking
file, but do not have permission to use a locking file created by someone
else.
 
I would highly splitting the database into a frontend/backend whenever you
are going to have multiple users. And and not only that, I would suggest
that you give each user a COPY of the frontend. That should solve your
problem AND it will lessen your chances of database corruption and losing all
of your data.

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
 
Back
Top