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
- arthurloibinSep 22, 2022Copper ContributorI tried this but I still got error. First time It look like it is working but after that I got errors.
- LorenzoSep 23, 2022Silver Contributor
No idea if the following option exists in Excel 2016:
If it does, refer to my 1st reply (to pottyponder) on this discussion
- arthurloibinSep 26, 2022Copper Contributor
I can't find the option in Excel 2016. In excel 2019 I tried this but it keeps asking for password.