Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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.
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.
?
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.
?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |