View Single Post
  #1  
Old June 3rd, 2010, 11:33 PM posted to microsoft.public.access.tablesdbdesign
Iram
external usenet poster
 
Posts: 122
Default "You attempted to open a database that is already opened exlcusivl

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