DataFormat.Error: Cannot open a database created with previous version of your application

[aktripathi2506]

Hi,

I am having Access 97 database. Otherwise I have microsoft office 2013. But the database is being used is still 97.

So I downloaded power BI 32 bit version and I was successfully able to connect power BI with Access database.

All the reports were dynamic and working fine.

But recently when I refresh the dataset, I started getting the following error:

DataFormat.Error: Cannot open a database created with previous version of your application

Please advise and help.

Th

Thanks.

[Eric_Zhang · Accepted solution]

@aktripathi2506

It seems a driver specific error. Check "Cannot Open a database created with a previous version of your application" error in Access 2013 and.... While in your case, since there's no pre-Access 2013 version of Access, try to export the tables in Access 97 to an excel sheet, and then load the excel to a Access 2013 db.

Alternatively you can try to install the legency driver Microsoft.Jet.OLEDB.4.0 or Microsoft Access 2010 Runtime(I guess this provider may work, according to the above KB link) and set up an ODBC DSN to the access 97 db. Then connect to the ODBC DSN in Power BI desktop.

[Didi_NewFlyer]

This likely is  a driver issue, but I can't figure out what I need. We had it working , and it still is working on another machine - appears to have the same versions of PBI, etc. How can I find out which drivers I have that I do not need, or which one I am missing. 

?

[Didi_NewFlyer]

This likely is  a driver issue, but I can't figure out what I need. We had it working , and it still is working on another machine - appears to have the same versions of PBI, etc. How can I find out which drivers I have that I do not need, or which one I am missing. 

?