List Box Event Problem

[Jinx]

My form has a combo box to select a client company, which
then populates a list box showing all the employees for
that company. I have a "DoubleClick" event on the List Box
that launches a form containing all the information about
the selected employee. I have never had any problem with
this working in the past.

A couple of months ago, I upsized the back-end (tables) to
SQL Server 2000, while the front end is still a MDB linked
to the SQL tables. I am in the process of changing (a
copy) the front end to an ADP, but not finished yet. Each
user has the exact same front end on their hard drive,
linked to the SQL back end. We are all using Access XP.

At times, the "DoubleClick" event does not seem to work
and will not bring up the employee form. It happens to
basically all the users some of the time, but sometimes it
works.

Any ideas? Thanks for your help.

 

[Michael Keating]

Hi,

I think you're encountering a record locking problem. The database will,
naturally enough, not let two people edit the same data, so if two users try
to access the same employee's info, one is going to fail.

I'm not certain of this, of course, and it would be worth testing, but I
have a strong feeling that you need to look in that direction.

HTH

MFK.