Database update problem

[Injun]

I have a vb application running on 32 machines and these machines are constantly updating differenet records in the database on the server.My app runs fine on all the machines doing the updates. The problem is, Sometimes certain records dont get updated right after the query is executed .Update comes into effect may be after an hour or so.
Any idea what is causing this delay? Any help apreciated.Thx

 

[QJohnson]

Some more information would be useful here.

Are the problem updates always made from the same workstations? This could indicate network hardware issues for those particular workstations.

Are the problem updates visible from some workstations, but not others?

Do you have consistent caching configurations on all your workstations?

Are you using transactions to make your updates? If so, are you forcing the writes to the disk with them? (There are methods to do this with both ADO and DAO which we can help with if your resources are too skimpy on this topic; just let us know which model you use in your code.)