Multiple Users being blocked

  • Thread starter Thread starter Banshee
  • Start date Start date
B

Banshee

I have a database that is split. The back-end is on a network server and the
front-end is on each individual user's desktop. There are 4-6 people working
on it at any one time. It seems to be working fine but periodically one of
the users gets blocked when they try to enter a new record. I have an auto
number field in the database and think maybe that has something to do with it
but I'm not sure. The blocks are really slowing down progress, can someone
help me out with this? thanks.
 
"one of the users gets blocked"
what are the symptoms and precisely when does it occur?
An autonumber field should not present any problems.
Is any special code running when a new record is created?
Are you sure the problem is not just slow network speed?

-Dorian
 
I have a database that is split. The back-end is on a network server and the
front-end is on each individual user's desktop. There are 4-6 people working
on it at any one time. It seems to be working fine but periodically one of
the users gets blocked when they try to enter a new record. I have an auto
number field in the database and think maybe that has something to do with it
but I'm not sure. The blocks are really slowing down progress, can someone
help me out with this? thanks.
Click to expand...

Do all users have full read/write/update/delete privileges to the *folder*
containing the backend?
 
There is an error code 3218 "Could not update, currently locked" To my
knowledge there are no special codes I didn't create any. Network speed is
good.
 
Yeah, they all have priveleges, the lockout only happens sometimes. It seems
to happen more often when there are more users at once.
 
There is an error code 3218 "Could not update, currently locked" To my
knowledge there are no special codes I didn't create any. Network speed is
good.
Click to expand...

This error suggests that two users are attempting to simultaneously update the
same record. Is this possible in your environment? How would you want to
handle it if Joe wants to update the record to X and Sally wants to update it
to Y at the same time? They can't both win!
 
That's the thing though, they are hitting the new record button, inputting
information and moving on. They don't ever go back to edit an existing
record.
 
Banshee said:
Yeah, they all have priveleges, the lockout only happens sometimes. It
seems
to happen more often when there are more users at once.
Click to expand...

Try providing a "new record" button that sets the Dirty property to False as
soon as the new record is created.

Keith.
www.keithwilby.co.uk
 
Back
Top