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/