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.
--
Milton Purdy
ACCESS
State of Arkansas


"LG" wrote:

> 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
>

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.

"LG" wrote:

> 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
>