Access Microsoft Jet

Discussion in 'Computer Software and Operating Systems' started by FrithjofEgeland, Nov 23, 2016.

  1. FrithjofEgeland
    OP

    FrithjofEgeland Newbie

    Newcomer
    3
    1
    Nov 23, 2016
    Norway
    Hello users!

    Maybe someone had this error when open the .mdb database Access.

    " The Microsoft Jet database engine stopped the process because you and
    another user are attempting to change the same data at the same time.
    (Error 3197)"


    I was told that this can happen if hung computer. Please tell me how to restore this database?

    Thanks in advance.
     
    GonzaloMendez likes this.
  2. Youkai

    Youkai Demon

    Member
    2,211
    291
    Jul 1, 2004
    Germany
    Germany , NRW
    You don't really offer a lot of informations oO
    But it sounds as if the computer still thinks that you are using the database already, maybe check if there is an active session with this data and kick it out.

    Other possibilitys would be either an Anti Virus scanner making problems or whatever.
     
    FrithjofEgeland likes this.
  3. FrithjofEgeland
    OP

    FrithjofEgeland Newbie

    Newcomer
    3
    1
    Nov 23, 2016
    Norway
    I tried disabling the antivirus but this error still appeared again.
     
  4. GonzaloMendez

    GonzaloMendez Newbie

    Newcomer
    4
    1
    Nov 21, 2016
    Mongolia
    Monaco
    Apparently you are working with the database on the network. To correct the error, you need to disconnect from the network computer database and update the table on which the failure occurred. But first, before any experiments with the database, make a copy of it.

    — Posts automatically merged - Please don't double post! —

    Update the table can be damaged in many ways. For example, a request to copy its contents into a temporary table, delete the data from the table, and then again a request to restore them.

    And there is a very useful program Access Recovery Toolbox to access recovery.

    https://www.oemailrecovery.com/access_recovery.html
     
    FrithjofEgeland likes this.
  5. FrithjofEgeland
    OP

    FrithjofEgeland Newbie

    Newcomer
    3
    1
    Nov 23, 2016
    Norway
    Thank you all for your advice! I'm appreciative for your responses and help.