Multi-user problem

J

Jason O

Hi,

I seem to have inherited the maintenance of a fairly simple database set up
by a previous employee who has since left the company. However, the users
have reported that only one person can use it at once. All they are using is
a simple form for inputting survey information. Can anyone point me in the
right direction as regards what the problem may be & what to look at to
resolve it. (I will be getting further info today, hopefully).

Any help greatly appreciated.

TIA

Jason
___
 
L

Larry Daugherty

In the options make sure that Exclusive access is not checked. You
should also have record level locking set.

HTH
 
E

Ed Warren

You want to have a 'front end' and a 'back end' database. (Linked tables).
Each user should get a copy of the 'front end' (the forms, reports,
queries). There should be only one copy of the 'back-end' (the data
tables). To set this up run the database splitter wizard.

Ed Warren.
 
J

Jerry Whittle

I'll add to check the permissions on the network folder holding the database.
All users of the database require Read, Write, Create, and Delete privileges
for the entire folder and not just the database file. This is because Access
creates a little .ldb file named the same as the .mdb database file. This
little .ldb file keeps track of who is using the database. If it can't be
created, deleted, or edited, only one person can use the database at a time.
 
J

Jason O

I'll add to check the permissions on the network folder holding the database.
All users of the database require Read, Write, Create, and Delete privileges
for the entire folder and not just the database file. This is because Access
creates a little .ldb file named the same as the .mdb database file. This
little .ldb file keeps track of who is using the database. If it can't be
created, deleted, or edited, only one person can use the database at a time.
Click to expand...

Thanks everyone,

I had a quick look today & sharing & record-locking settings look ok. I
don't know yet about the front/back end thing. (Not something I've really
had dealings with). However, it seems that the only users affected are the
ones who are accessing the database from off site. They have access to the
office network's P:\ drive somehow. I have absolutely no experience in
network admin - anyone any idea what the issue might be. They also mentioned
getting error messages re synchronising (Win XP). (All users *in* the office
have no probs?)

Any pointers appreciated.

Jason
___
 
S

Srwe

Hi,

If you think it is not an Access 'thing' then it might, as mentioned by
Jerry Whittle, has something to do with permissions, in this case for those
groups who have access to the database from another place. You might ask the
administrator who assigns permissions to outside users in your network.
Firewall might play a role but I haven't heard anything like this before. You
may ask specialized newsgroups in this case.

Srwe,
Regards
 
T

Teri

Thanks for posting this question, and to all of you that responded. I was
recently asked if it was possible for more than one person to be using a
database at one time and I wasn't sure of the answer, now I know and I will
look into making it possible!

Thanks Again!!!!

Teri.
 
J

Jerry Whittle

Hi Teri,

Very possible. With a well designed Access database that is split into a
front end / back end residing on a robust wired network, you can easily have
20 people working in the same database.
 
Top