Connecting to an encrypted Access database after changing the Encryption Method

0
votes

Based on Accessing Password Protected MS Access file from excel, I should be able to go to Options > Client Settings and set the Encryption Method to "Use Legacy Encryption" and then be able to connect to my encrypted database through Excel Data Connections. However, when I do this, I still get prompted for the password repeatedly and eventually have to hit Cancel (and thus get no connection).

I am using Excel 2010 and Access 2010. My database is encrypted and has linked tables (as well as many queries, forms, reports, macros and VBA code).

Can anyone help me solve why this isn't working?

1
excelms-accessms-access-2010
You did re-encrypt the file after changing the Encryption Method setting, did you? – Gord Thompson
Thanks @GordThompson! That did it. Thank you! Thank you! Thank you! – Scott Holtzman

1 Answers

2
votes

Changing the "Encryption Method" setting for a database in the Microsoft Access settings does not automatically re-encrypt the file with the new encryption method. You must un-encrypt and re-encrypt the file for the new encryption method to take effect.