Results 1 to 4 of 4

Thread: problem (2k)

  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    problem (2k)

    i have a problem in my MDB can any help me to fix it . That msg is apear when i try to run it ( 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)
    Is there any Help for it .
    Ashraf

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: problem (2k)

    Does this happen always in the same place?

    It can happen if you have two different forms open that are trying to change the same record at the same time, or if you try to change a record though code (or an update query) while an unsaved record is open on a form.

    Another thing to check is that the ldb file is deleted when you close the database down.
    Regards
    John



  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: problem (2k)

    Have you tried Tools | Database Utilities | Compact and Repair Database...?

    If that, and the suggestions from John don't help, the database has probably become corrupt. There are some things you can try to repair it, or to salvage as much as possible:

    - Download Jetcomp.exe from Jet compact utility is available in download center; this utility can sometimes repair databases that the internal 'Compact and Repair' cannot handle.
    - Create a new blank database and use File | Get External Data | Import... to import as many database objects from the problem database as possible.
    - Try to import the tables into Excel (Data | Get External Data | New Database Query...); the ODBC driver operates at a low level and may be able to get at the data. This won't retrieve other database objects (forms etc.)

    If these fail, you are out of luck. Going back to the most recent non-corrupt backup you have is the best you can do then, but of course, you may have lost some data.

  4. #4
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: problem (2k)

    i try all the steps that u said hans and also download the Jet compact but all faild . thanks for all
    Ashraf

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •