NEWBIE DESIGN QUESTION / LOCKING ISSUES

[JackQ]

I am having such a frustrating problem and would appreciate any advice.

I have a split database and have approximately 15 front ends. All of a
sudden, i am getting some bizzare record locking error message. I have a
table which allows users to select via a combo box a patient's name. There
seems to be no consistency to it, but every so often, when a user goes to
select a name from a list of patients, it completely locks up and states
there is a record lock. I have no idea why this is doing it now and hasn't
done this before?

I have also experienced when a user goes to select a field, it seems to
jump to another totally different field when selected.

Please help!

 

[mscertified]

Its almost impossible to diagnose such a problem over this forum. For the
first problem I'd start by running the LDB viewer utility to make sure all
users are logging on and off properly. Also, I'd make sure no user is opening
the back end directly or no users are sharing a copy of the front-end (every
user needs their own individual copy).
If there is any VBA code in the database that reads tables or queries, make
sure they are using a READONLY recordset.

-Dorian