Access database connection error for .mdb file

[cbpurnima]

Hi,

I am trying to connect and get data from Access db folders with .mdb file in Power BI Desktop but its throwing below connection error-

Unable to connect
We encountered an error while trying to connect
Details: "Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider may be required to read '*****.mdb'.
To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987."

Let me know, how to troubleshoot this error.

Thanks for your help.

[amitchandak · Accepted solution]

@cbpurnima , I think you need to download Microsoft.ACE.OLEDB.12.0 provider and install

https://www.microsoft.com/en-in/download/details.aspx?id=13255

[PhilipTreacy · Accepted solution]

Hi @cbpurnima 

Have you tried installing the 64 bit Access DB engine as the error message suggests?

Regards

Phil

[amitchandak · Accepted solution]

@cbpurnima , I think you need to download Microsoft.ACE.OLEDB.12.0 provider and install

https://www.microsoft.com/en-in/download/details.aspx?id=13255