Access database update slow
Posted on 2004-08-03
I am updating an access database via VB. Immediately after the update I reload a tree based on results of the update. Values that should not be in the tree appear. If I refresh the tree they disappear or if I use a timer to slow the operations down they'll load properly. The problem with the timer is it slows the whole project down even if there were only a small number of updates and since it's processor dependant I'm afraid it will be very slow on older computers. When I ran at full speed the database would be locked before the updates completed and that would cause a crash. I guess the question is how do I make sure that updates are complete before the program moves to the next function. Is there a return value that can be captured when the update completes? Thanks in advance.