Constant "Unregonized database format" error on a MSFT Access DB no matter how many recovery has been done to it.

Posted on 2007-07-25
Last Modified: 2012-06-27
We keep running into a problem with a particular Microsoft Access database. It would give us the following error:

"Unrecognized database format"

We would recover the tables, start a new database. After any user opens and closes the database for the first time, the second user will run into that same error.

The file is encrypted using PGP NetShare. I would usually blame the encryption, but we have more than 3 databases that are encrypted with PGP NetShare and only one of them would give us this problem. Any idea why?

Question by:nakedconsulting
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    A **DeCompile** may help here ...

    But first, if you have not already:
    Check for any **Missing References via the VBA Editor>>Tools>>References ....

    Then, follow this procedure:

    0) **Backup your MDB**
    1) Compact and Repair the MDB, as follows:
    Hold down the Shift key and open the MDB, then from the menu >>Tools>>Database Utilities>>Compact and Repair ...
    2) Execute the Decompile (See example syntax below) >> after which, your database will reopen.
    3) Close the mdb
    4) Open the mdb and do a Compact and Repair (#1 above).
    5) Open the mdb:
        a) Right click over a 'blank' area of the database window (container) and select Visual Basic Editor. A new window will open with the title 'Microsoft Visual Basic' ... followed by then name of your MDB.
        b) From the VBA Editor Menu at the top of the window:
            Note ... after the word Compile will see the name of your 'Project' - just an fyi.

    6) Close the mdb
    7) Compact and Repair one more time.

    *** Executing the DeCompile:
    Here is an example of the command line syntax  (adjust your path and file name accordingly) for executing the


    Run this from Start>>Run, enter the following command line ...

    "C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile


    For more detail on the Decompile subject ... visit the Master on the subject (and other great stuff) Michael Kaplan:

    LVL 84

    Accepted Solution

    If your database networked? One of the more common issues with Access/Jet databases is faulty network hardware. Dropped or glitched connections will eventually kill a Jet database.

    You're not running this over a WAN, are you (i.e. a VPN or other WAN-type connections)? I'm familiar with PGP but not NetShare ... I'd assume this is just some server-based encryption business?
    LVL 84
    Have to ask - why the "B" grade? You asked no followup questions, and the answers that mx and I gave were pretty thorough ...
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    I was wondering the same thing?


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    731 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

    15 Experts available now in Live!

    Get 1:1 Help Now