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
Another method to change the encryption type in access 2007, using a 3rd party tool