Forum Discussion

BAFreedom's avatar
BAFreedom
Helper I
3 years ago

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

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: ...
Need Help
ValtteriN's avatar
ValtteriN
Community Champion
3 years ago

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's avatar
    Chopper_84
    New Member
    1 year ago

    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's avatar
      Chopper_84
      New Member
      1 year ago

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