Multiple users see table changes at different times?

M

mscertified

I have an application where users pull records from a common table which acts
as a queue. The problem I am having is that different users are pulling the
same record. I do have a locking mechanism which I have tested and it works
flawlessly. This locks other users out while certain operations are
occurring. However, what is happening is that when I delete the processed
record from the queue (and I have tried both DELETE SQL command or .DELETE
via recordset), other users are able to retrieve the record AFTER the delete
takes place. I have proven this by issuing traces from each user. Does anyone
know why this happens and how I may prevent it? If I insert a delay loop
after the delete, it happens less often but I have not been able to find any
length of delay (other than a totally unacceptable one) that guarantees no
conflict will occur.
 
N

NetworkTrade

the only situation I am aware of regarding a user not seeing the current data
in a table is because their form has not been refreshed....and they are
seeing the data that was current when the form initially opened. this is
fairly common with comboboxes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple users 'pulling from queue table' 1
Multi-user table access problem 4
Strange multi-user timing phenomenon 7
Error: Argument Not Optional 0
Retrieving 'first' record in table 3
Locking for multiple user access ? 4
Coding form to change multiple records 5
Locked Subform still lets me delete a record 2

Top