A customer has an Access database (.accdb), which was encrypted/given a database password in Access 2013. It should be possible to read that data from Excel 2010/2013, but when clicking on Data-->From Access and the correct path is put in and the correct database password has been entered, Excel just keeps prompting for the database password. This happens with both Excel 2010 and 2013.

The database password supplied is correct as evidenced by opening the database in Access 2013 using the same database password.

A colleague in a separate company has found that a separate .accdb file he has recently encrypted also has the same problem as above, yet a .accdb file encrypted ages ago is readable from Excel.

How do I get Excel 2010/2013 to read the data from the encrypted .accdb file, please?

Since Access 2010 the encryption algorithm has changed:

Source

This results in not being able to connect programmatically to an encrypted db via DAO (using VBA). In that case error 3031 is raised  (Not a valid password) although the password is correct.

Cheers,
Emiel Nijhuis

• Edited by enijhuis 10 hours 16 minutes ago