User locks database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an application that opens a form when Access opens. I have 17 users.
Several use runtime 9.0. I have 2 users (using runtime) that lock the
database and others can not open it if one of these 2 users opens it first.
When they open it first they get a message stating that any changes they make
may not be saved. When they click OK, they can continue and can make changes
that are saved. (Doesn't make sense to get the message)

If another user opens the database first, the 2 problem users can open it,
they don't get the message and they can use the database. Other users can
also open the database while these individuals have it open.

It appears that the settings on these 2 computers are the same as other
users that don't lock the database. All users go to the same form when the
database opens. This has become very frustrating. Please help.

Thanks
 
Are you using a separate front-end on each work station, and is record
locking set on the main form?
-Ed
 
Everyone uses the same front-end - it is on the server. I'll have to check on
the record locking on the main form however if it was set, wouldn't it lock
the record (database) when any user opened the application? The issue I have
is with 2 particular users.

Thanks
 
Your current setup is part of the problem, and I'm surprised that there
haven't been more problems. Each workstation should have a separate/local
front-end app - linked to the data tables on the server. Most/all data
entry forms should have the record-lock property set to "edited record".

-Ed
 
Back
Top