CODEWITHSUNDEEP
excelms-access
KillerSnail
KillerSnail

Reputation: 3591

Accessing password protected MS Access file

I have encrypted an Access file via the encryption option under File > Info.

In Excel when I try to retrieve a table from the Access file it pops up a password box but it doesn't accept my password. I can link from Access file to Access file no problems.

Does anyone know what the problem is?

Upvotes: 3

Views: 9393

Answers (1)

KillerSnail
KillerSnail

Reputation: 3591

Solved. I went to File Access options Client settings and set the encrption method to "Use Legacy Encryption" then redid the password

Upvotes: 7

Related Questions