Can a combo box lock the database?

  • Thread starter Thread starter Carl Rapson
  • Start date Start date
C

Carl Rapson

I have a split Access 2002 application (FE on users' systems, BE on server).
One of the forms has a combo box with an SQL statement as its record source.
Today a user opened the combo box (dropped down the list) and then walked
off and left his computer. The BE file was apparently locked, because other
users suddenly couldn't connect to the BE. As soon as the user closed the
combo box, other users could connect again. Is this normal behavior for
combo boxes? Is there any way to prevent this from happening again?

Thanks for any information,

Carl Rapson
 
Hi Carl.

Merely dropping down a combo box would not cause this. Perhaps there was
something else as well, such as code in one of the combo's events, or
attempts to change record, or a network/power glitch that caused him to
momentarily disconnect from the back end while the form was dirty, or ...

You might like to see if there is still an LDB file left in the folder where
the back end mdb resides after all users log out. If so, it may indicate
that Access thinks the dropped-out user is still present (since they did not
log out), and so still contains spurious locking info. If so, delete the
ldb.
 
Allen,

Thanks for the suggestions. There was no .ldb file left over after the user
disconnected, but I'll look into the other possibilities.

Carl
 
Back
Top