Forum Discussion

Didi_NewFlyer's avatar
Didi_NewFlyer
Frequent Visitor
10 years ago

Desktop BI MSAccess - Cannot open database created with a previous version....

We had actually had all the issues worked out and had a connection to the MS access db working. Then all of a sudden it stopped given us again this issue regarding the "created in a previous version"...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Didi_NewFlyer,

Would you mind sharing me the Access97 database file? I will test in my Power BI Desktop.

I suspect that Power BI Desktop will not work with such an old Access database, I would recommend you that upgrade the Access97 database to higher version such as Access 2010 database or Access 2013 database, then connect to it from Power BI Desktop. You can follow the steps in this article to upgrade Access97 database.

Moreover, you would need to install Microsoft Access Database Engine 2010 Redistributable when you connect to Access 2010 database or later version from Power BI desktop, please ensure that the Microsoft Access Database Engine 2010 Redistributable you install matches the bitness of Power BI Desktop.




Thanks,

Lydia Zhang