Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Error Number 3197: msAccess (https://www.askmehelpdesk.com/showthread.php?t=37019)

  • Oct 14, 2006, 12:17 AM
    tushar_more99
    Error Number 3197: msAccess
    Error number 3197 : The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

    My MS Access File has been corrupted, how to repair this file
  • Oct 14, 2006, 02:58 AM
    Curlyben
    This article gives a full break down of your problem.
  • Oct 14, 2006, 05:39 AM
    ScottGem
    The article Ben linked to shows you how to attempt a compact and repair. Hopefully that will work. If it doesn't work let us know there might be other things you can try.

    Once you have gotten the database fixed, you should take steps to prevent this happening again. If this database is a multi-user app it NEEDS to be split. Splitting involve taking all the tables and putting them into a back end file. Access includes a wizard (under Tools>Database) to do this for you. The wizard creates the new file, moves all the tables into it and creates links in the front end to those tables. You then put a copy of the front end on each user's PC.

    You also need to create a backup policy so you have a backup copy of both the back end and the front end at least daily.

  • All times are GMT -7. The time now is 01:37 PM.