Forum Discussion
Error in opening an accdb file
Hi AbelNewton,
I can successfully connect to your accdb file from Power BI Desktop. In my environment, Power BI Desktop, Microsoft Access Database Engine 2010 Redistributable and operating system are all 64 bit.
Have you installed 32-bit Access Database Engine 2010 Redistributable? Also is the access database file upgraded from lower version of Access to Access 2016? If so, please repair Access firstly and then install 32-bit Access Database Engine 2010 Redistributable.
In addition, if you are on a 64 bit OS, you can consider to install the 64-bit Access Database Engine 2010 Redistributable using the /passive switch at the command line, which is discussed in this similar blog, then use 64-bit Power BI Desktop to connect to the Access database.
Thanks,
Lydia Zhang
- mllopis
Community Admin
Please check this troubleshooting article for more details regarding the cause and potential workarounds: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-access-database-errors/
Thank you... Step 3 was the solution i.e. https://www.microsoft.com/en-us/download/details.aspx?id=13255
The links on that page - https://docs.microsoft.com/en-us/power-bi/desktop-access-database-errors - show HTTP Error 400. The size of the request headers is too long.
mohdmohideen200Helper I
It means that permission to do something has been refused.
