none
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

     

    http://support.microsoft.com/kb/200300/en-us

     

    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
    Moderator