Remove record from queue in multi user enviroment 1

[wokkie]

I have a database where the users work from a queue. They hit a button and the next record opened in a form.

I have an attibute "open" which I set to true when the user opens the form, using recordsets and update.

The problem is that the update is too slow and more than one user can open the same record if the hit the button at the same time.

Is there a better way to prevent more than one user opening each record?

I am using Access 2000 on NT4 with about 5 concurrent users.

Thanks

Ian

 

[bboffin]

Can't you use the BeginTrans and CommitTrans methods?

You would call BeginTrans before getting the next record in the queue and, assuming this worked, you would do the update then call CommitTrans. If it failed you'd call RollBack and try again.

Take a look at the help on these methods and it should solve your problem.