How to connect to a Microsoft Access Database (Password Protected)?

[BAFreedom]

Hello,

I am trying to connect Power BI to a password-protected MS Access File.

When I try and get the data by clicking "get data" in Power BI, select the MS Access file, it results in this:

I need the MS Database to be password protected, as all data contains confidential information.

Thank you.

[Syndicate_Admin]

I've tried your solution, but I entered the wrong username and password then error, when I try to enter the correct username and password, the menu doesnt show up, only error like this

help me to solve it pleasee..

[ValtteriN]

Hi,

Instead of using MS Access connector use ODBC connector like this:

Driver:
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=YourPath\YourDB.Filetype

In the pop up enter Admin and password:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Chopper_84]

Hi ValtteriN,
your solution worked for me. Thank you for that.
But I have now the issue that one table from the database is getting me this error. When I Open the table in Access it is there and I can not see why it should not be accessible. Database is quite old. 2007 or so. 

If you have a hint for me? 
Thanks

[Chopper_84]

Might not be the best solution but converting the database to .accdb resolved the second issue as well.