"Error:Unable to open Access database" when attempting to compare databases RRS feed

  • Question

  • I am attempting to use the Microsoft Database Compare utility to compare the designs of two databases (I believe that they are identical, but not absolutely sure). Each time that I attempt to use the utility I receive the error "Error:Unable to open Access database". I am then prompted to supply a password, but the databases are not password protected. This happens regardless of what database I use. All of these databases open and function normally when opened directly in Access.

    Any ideas?

    Saturday, June 9, 2018 9:49 PM

All replies

  • When I just tried it, the application actually crashed. 

    Do you perhaps have a password on the VBA project (rather than a database password)?

    -Tom. Microsoft Access MVP

    Sunday, June 10, 2018 1:35 AM
  • Nope. No passwords on anything.
    Sunday, June 10, 2018 5:02 AM
  • Hello SlimJimPoisson,

    If you create a new database file with some simple data and copy it, and then what's the result of comparing the newly created database and its copied database?

    If you still get the error, I would suggest you repair your office and then try the test again.

    If you do not get the error, I think the issue is more related to the specific database file.

    I would suggest back up your database file(important), and then select report options in the compare tool one by one to check if tables or queries or macros... caused this error. Once you make sure which part caused this error, delete the object in it one by one until you does not get the error.

    If so, the latest deleted object should be the reason of the issue. Check its design.

    Best Regards,


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, June 11, 2018 6:55 AM