Problem with two connections to MS Access database RRS feed

  • Question

  • I have the two connections to one Access Database. First connection insert some data to database using OleDbDataAdapter.Update and then the second connection read data from the database, but I receive old datas without inserted by the first connection.


    When I try again read data by the second connection after 1-2 seconds everything is ok.


    How can I solve this problem without delays

    Friday, June 22, 2007 5:28 AM

All replies

  • It is because Jet caches changes and does not apply them immediately against the database. This behavior described in next article




    I believe, in addition to what described there, you could use database transaction that applies changes right after you commit it


    Friday, June 22, 2007 10:13 AM