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

[Didi_NewFlyer]

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". We have 32 bit installed. The MSAccess db is 97, we are using a 97 runtime program to open it. I don't understand what changed. But i have tried everything!

[v-yuezhe-msft]

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