Wait for Process to Finish

[Jengo]

I need help. I am accessing an access 2000 database throught vb's ADODB connection. When I run an update, insert or delete statement I then get the new data from the Database. But the data is attempting to query the updated data too fast. The update statement has not finished yet. Is there a a way to tell my program to wait until the database is complete its updates before querying the data.

 

[dalchri]

This problem may also be caused by using more than one database connection. For example, if you append the data using one connection object and query the database using a different connection object, these sorts of timing issues may occur. If possible, try using the same database connection object.

If you already are using the same connection object, I'm out of ideas.