"The Database "|" can't be repaired or isn't a Microsoft Access database file.

Posted on 2012-09-18
Last Modified: 2013-04-02
I have recently migrated to Windows 7 and am having trouble when I try to open a database from an external hard drive (or a USB).  I receive a message saying,

"Microsoft Access has detected that this database is in an inconsistent state.......:"

When I click OK, I then get the message

 "The Database "|" can't be repaired or isn't a Microsoft Access database file."

If I transfer the file via a network connection, everything is OK so it only seems to be an issue with the external storage.  (I have tried copying from the external hard drive to the local drive, but it still won't open once it has been ON the external drive.)

This same issue occurs when I am using a USB drive, and with several different databases, so I'm pretty sure that it is not a problem with the individual media or data I am using but rather with the process.

Any guidance you could give me would be greatly appreciated.

Thank You
Question by:RustyRhonda
    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    <<Any guidance you could give me would be greatly appreciated.>>

     Sounds like it's the drivers for the USB/External storage within Windows.

     As far as JET is concerned, there's no difference between one drive and another.

     Make sure your up to date on windows updates and then give it another go.

     Also, how are you getting stuff onto the USB/External drives; with the same machine or another?

    LVL 56

    Accepted Solution

    One finial thought; turn off any anti-virus utilities you have; it may be trying to repair the file as it's copied to/from the external drive.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Title # Comments Views Activity
    Format Number Field 10 34
    Calculating total percentage per row in Oracle Query 2 22
    Pl/SQL Query 31 35
    Introduction Hopefully the following mnemonic and, ultimately, the acronym it represents is common place to all those reading: Please Excuse My Dear Aunt Sally (PEMDAS). Briefly, though, PEMDAS is used to signify the order of operations (http://en.…
    PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now