Results 1 to 13 of 13
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unable to Open Database (Access 2000/XP)

    When I try to open a specific database, I get the following error: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time"

    There is no ldb file indicating the file is opened by anyone else. In fact I copied it from the server where it was located to my hard drive but the copy acts the same way. I tried compact and repair without the database open and receive the same error message. I tried importing into a new database and the same message appears nor will it let me open it in exclusive mode. Is there any way to open a database that behaves this way?
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

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

    Re: Unable to Open Database (Access 2000/XP)

    That doesn't look good.

    Microsoft provides a standalone Compact -and-Repair utility: Jetcomp.exe. You can download it from ACC2000: Jet Compact Utility Available in Download Center. It can repair some problems that the internal Compact and Repair option can't handle.

    If this doesn't help either, going back to a recent backup may be your best option...

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to Open Database (Access 2000/XP)

    I downloaded this file but it was unable to fix the problem. I simply comes back with an error that it is unable to compact the file. In reading the documentation that came with this file, it appears that the message I am receiving is probably caused by a memo field that has bad data stored in it. When compact has a problem it usually indicates what is wrong in a table it leaves behind within the database. But when it does not let you open the database, you can't do much of anything.

    I had also tried another standalone compact program called Access Maintainer that I purchased after reading about it on this board. It has helped in the past but not in this situation.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

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

    Re: Unable to Open Database (Access 2000/XP)

    I'm very sorry for you. Unless somebody else comes up with a new idea, I fear that the database is irrevocably lost. I do hope you have a fairly recent backup...

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Unable to Open Database (Access 2000/XP)

    From your description, I assume that your data and interface are all in the same mdb file, right? If you, can you open the database with the shift key held down to bypass any "processing" and get to the tables?
    Charlotte

  6. #6
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to Open Database (Access 2000/XP)

    The database I am trying to open is actually the backend of a database that is in the past years folder from two years ago. At your suggestion, I tried opening the database while holding down the shift key but I get the same error. I also get the same error when I try to open the backup file that I had our helpdesk restore for me. It sounds like the file is toast, unless there is something else I can try.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

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

    Re: Unable to Open Database (Access 2000/XP)

    I don't think this will work, but you might try getting data from the tables in the database using ODBC. This operates at a lower level than Access itself.

    For example, open Excel.
    Select Data/Get External Data/New Database Query...
    Select an Access data source, or create a new one.
    Follow the steps of the Wizard, selecting the database, table etc.
    I don't know whether you'll be able to exit gracefully if ODBC can't open the table - you may have to use Task Manager to get out <img src=/S/sorry.gif border=0 alt=sorry width=15 height=15>.

    I wish you success, but I fear that your database is beyond recovery.

  8. #8
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to Open Database (Access 2000/XP)

    <hr>It sounds like the file is toast<hr>


    Butter side down? <img src=/S/sad.gif border=0 alt=sad width=15 height=15>
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  9. #9
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to Open Database (Access 2000/XP)

    I tried using Excel to get to the tables but I get this same error message. I appreciate all the suggestions that have been provided because even though they did not work with this file, I will remember them to try in the future with other databases I have trouble opening.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  10. #10
    2 Star Lounger
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to Open Database (Access 2000/XP)

    I have had success with creating a blank database and importing the data from a partially corrupted database. If you've already tried through Excel, it may be an indication it won't work, but it's worth a try.

    Eric

  11. #11
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to Open Database (Access 2000/XP)

    Importing into a blank database was one of the first things I tried because that has helped in the past. It appears that this database is beyond repair.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  12. #12
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Unable to Open Database (Access 2000/XP)

    Since you've already tried to import to an empty database, it looks like a serious corruption. That kind of thing can happen if you try to open an MDB file from Word, Excel or any of a number of other applications - it can also happen because the network went south during a write, a user PC crashed during a write and a number of other things. There are companies who will extract whatever data is extractable for a princely sum, so if the data is really important you could look at that option. Otherwise, it sounds like it really is toast.
    Wendell

  13. #13
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to Open Database (Access 2000/XP)

    (Edited by HansV to make links live - see <!help=19>Help 19<!/help>)

    Hi Judy

    You may want to check out <post#=215424>post 215424</post#>. Check out Corrupt Microsoft Access MDBs FAQ:
    http://www.granite.ab.ca/access/corruptmdbs.htm

    If your DB is valuable, I think the above link lists vendors who do DB repair, If nothing else you can use it for future preventive maintenance reference.

    There are two type Access users:

    1. Those that have had Corrupt Db's
    2. And those that will

    Keep us informed!

    HTH

    John

Posting Permissions

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