Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    cannot open mdf file (Access 2003)

    I have an Access database file in 2000 format. When I tried to open the file, I received the following msg

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

    I have tried to import the data into another database but end up with the same error msg. I hold down the shift key and then click on the database, same error.

    Any suggestions will be appreciated.

    thanks

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

    Re: cannot open mdf file (Access 2003)

    It sounds like your database is seriously corrupt. 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.
    - 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, but of course, you may have lost some data.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: cannot open mdf file (Access 2003)

    Hi Hans,

    I had tried the MS compact utility program. It could not open/compact the damaged file at all.

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

    Re: cannot open mdf file (Access 2003)

    I'm afraid your database is corrupt beyond repair. Sorry. <img src=/S/sorry.gif border=0 alt=sorry width=15 height=15>

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: cannot open mdf file (Access 2003)

    Charlotte suggested a decompile which worked where other methods have failed.

    Just a shot in the dark.

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

    Re: cannot open mdf file (Access 2003)

    But decompile requires that Access can still open the database. It won't hurt to try it, but I fear it won't work.

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

    Re: cannot open mdf file (Access 2003)

    Is this a backend, frontend or combined database? Have you made certain that there are no other databases linked to it that might be open? And was the "mdf" in the subject line a typo? SQL Server has mdf files, not Access.
    Charlotte

  8. #8
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: cannot open mdf file (Access 2003)

    it is a both front and back-end. All the forms, reports, queries, and tables are stored in the mdb file. Nothing, except Excel, can touch the file. I was able to use Excel to import some of the tables. One table, invoice details, is too big (too many records) to fit into Excel.

    What surprises me is that the file that I copied from is working perfectly. Only the copied file is having problem. When I made the copy, everyone had logged off from the program already. The mdb file was not open at all.

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

    Re: cannot open mdf file (Access 2003)

    I would strongly suggest that you split the database into front end and back end because your risk of corruption is far higher with a combined database than with it split.

    I don't think you had previously mentioned that you copied this database or that the original worked properly. What was the purpose of copying the database? You cannot perform any data entry on a copy anyhow without risking overwriting someone else's input, so what were you trying to accomplish? From the sounds of the error messages, there's something going on inside the database that prevents you from compacting it. A timer would be my first thought. Can you examine the design of the original to see?
    Charlotte

  10. #10
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: cannot open mdf file (Access 2003)

    I was making a backup copy so that I could take it home to run some analysis on the data.

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

    Re: cannot open mdf file (Access 2003)

    You've just discovered one of the good reasons to split the database into front and back ends. If it were split, you could simply copy the backend to your machine and run any analysis you pleased on it without running into extraneous issues.
    Charlotte

Posting Permissions

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