0
votes

I'm in excel/vba, I need to open a password encrypted accdb database file.

According to

connectionstrings this feature is broken and always fails with a "Not a valid password" error

I have tried saving the same database as an mdb 2000, mdb 2003 and an accdb file each with an added password, they all open except accdb

I would like to know, when using accdb, if you enable legacy encrytion, do you get the cardboard-level protection of previous access version or something in-between ?

thanks !

More links

Someone else with my problem

The solution so far

A method to change the encryption default with the office customization tool, I can't as I have no admin privileges

Another method to change the encryption type in access 2007, using a 3rd party tool

1
Actually, the last link in your question answers the basic portion of your question rather thoroughly, IMHO. - Jiggles32
I don't believe so, it says that the default encryption provider for post-2007 Access is RC4. That is the default, but it does not say what encryption is used when "legacy encryption" is select - Shodan

1 Answers

0
votes

Since you seem to be possibly interested in 3rd party solutions, NetLib Encryptionizer provides seamless TDE to Access databases. (Disclaimer: I am from NetLib Security).