I
Iram
Two days ago I deployed a split 2003 access database that is accessed by 20
users. Since going live with it I have noticed many people having trouble
with hanging or crashing of the front end. When I try to open the back end I
get the message "You attempted to open a database that is already opened
exlcusively by user 'Admin' on machine 'Comptername'. Try again when teh
database is available. Then I track down who the PC belongs to and check what
is going on. What I find on all the PCs that have made the back end give this
error is that the user starts adding a record but doesn't completly finish
it. They are just leaving a new record half ass. Once they complete the
record the everyone else can continue to add records. So it seems that when
one person leaves a record not completely finished for long periods of time
it causes problems for everyone else.
I do want to mention that I have an AutoNumber field using the "Random"
feature.
Can anyone help me resolve this problem?
Thanks.
Iram/mcp
users. Since going live with it I have noticed many people having trouble
with hanging or crashing of the front end. When I try to open the back end I
get the message "You attempted to open a database that is already opened
exlcusively by user 'Admin' on machine 'Comptername'. Try again when teh
database is available. Then I track down who the PC belongs to and check what
is going on. What I find on all the PCs that have made the back end give this
error is that the user starts adding a record but doesn't completly finish
it. They are just leaving a new record half ass. Once they complete the
record the everyone else can continue to add records. So it seems that when
one person leaves a record not completely finished for long periods of time
it causes problems for everyone else.
I do want to mention that I have an AutoNumber field using the "Random"
feature.
Can anyone help me resolve this problem?
Thanks.
Iram/mcp