I am having a little trouble with working with a database and wonder if anyone might know a solution. I am using a MS Access database and the Jet driver. Also I am using OleDbConnection, OleDbCommand, ExecuteNonQuery()... etc. (not using DataSet)

Right now, I can read and write to a database no problem. However, I am doing this rather quickly. For example, I write to the database then immediately read from it. The database cache isn't updating the database file in time so the old information is read.

Is there any way I can force the database cache to update the database file? Or is there any way I can check that the database cache has written the data to the database file?

Thanks in advance! :)