Database Locked

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

Any ideas....
I have a DB with securities set up with FE and BE. We now have more users
than previous about 15-20 compared to 5. Sometimes as the processors are
entering into the forms it will freeze and say it's locked (yes they are
working in a form that feeds the same table). Other times other people will
try to login to the DB and says that a person has it locked. How does that
happen if they don't have admin rights?
Even myself with admin rights can't get in unless I log them out and have
them log back in.
Does this sound familiar? I did a compact and repair already and still the
same.
Thanks in advance
 
Go to tools\options\advanced. Set to shared and to edited record. Make sure
every user has read\write\edit\ and delete rights to the BE AND the folder it
resides in. Then you may still occasionally have locking problems but most of
it will be eliminated. Also make sure that when a user gets off the system,
their name drops out of the ldb.
 
It sounds as though your form(s) is directly connected to the tables in
question. I would put a table (call it table 1) behind the form that mirrors
the data table. Set your switchboard (or whatever you use) to run a delete
query for table 1. Run an append query that will pull the record(s) in
question out of the data table. After you make your changes, run an update
query. The update query should be linked on the data table using the same
fields you used to pull your data out.
 
Back
Top