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.
 
Ad

Advertisements

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
 
Ad

Advertisements


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

Top