Forum Discussion
Unable to Import data from password protected Microsoft Access Database
If you're using the same workbook from the old version of excel, the first thing I'd try is GetData/Data Source Settings
Then select the source with the access DB and click Clear Permissions, then Click on Edit. You should have the option to select different credential types like default, database, windows, etc. Pick the appropriate one (I'm not sure if Access will be an option, so perhaps either database or default might work). Then enter your credentials again.
I'm shooting blindly here as I've no access database to test, although this method has proven successful in resolving several other credential related issues.
Good luck.
Dexter
No idea if the following option exists in Excel 2016:
If it does, refer to my 1st reply (to pottyponder) on this discussion
I can't find the option in Excel 2016. In excel 2019 I tried this but it keeps asking for password.
I don't have Excel 2016 nor 2019 so can't check how this works with those versions. However...
If Excel 2016 doesn't expose a "From Access (Legacy)" option I guess it's because that version uses this old/legacy connector by default (just a guess, not sure)
Re. "I tried this but it keeps asking for password". If you talk about the following dialog box:
It's expected as the password (for such Legacy connector) is not stored in the Data Source Settings
