Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2008
    Posts
    2

    Unanswered: error 3197 database doesn't open

    Hi,
    I am not able to open database in access2003 because of error 3197.
    Everytime when trying to open ,the same message appears on the screen:

    "The Microsoft Jet engine database stopped the process because you and another person are attempting to change the same data at the same time".

    I have tried to import that file in the new database,but that doesn't work. Even when my copy the database on other machine, same error message come up. Some one suggested it might have to do with enabling the database for multiuser access but i can't even open the database.

    Does anyone know how to open the database with error 3197?

    Any help is appreciated.
    Thanks,
    Baba

  2. #2
    Join Date
    May 2005
    Posts
    125
    Provided Answers: 1
    Hi, I can't give you a definative answer, but if you google "error 3197", you'll get a list of forums, may be they can help

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Hold shift when opening the file; this will cancel any operations that fire on starting the application. Then you'll have to fish around the code that's firing to find the badger causing this mess
    George
    Home | Blog

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I've run into this one before too. It could be indicative of file corruption. Sorry for that. Best solution for that is to restore it from a backup.

    You can also try deleting your .ldb file for your database and see if there really is someone else trying to use it. If the file isn't there or lets you delete it, then the database isn't open. If the system denies you the ability to delete the file, then someone else on your network has it open.

    HTH
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Jan 2008
    Posts
    2
    Thanx......But dbase doesn't have .ldb file.what should I do now??

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Restore it from a backup?

    Can you open the database when you hold SHIFT as suggested in post#3?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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