Access 2013 - Cannot open a database created with a previous version of your application

ms-access ms-access-2013
Uma Ilango picture Uma Ilango · Jun 9, 2014 · Viewed 107k times · Source

I have an Access database created more than 10 yrs back.

I have very important data in it & I think it can be opened in Access 2007 or earlier version. Currently I have Access 2013 in my desktop and opening the file with this version results in the error "Cannot open a database created with a previous version of your application"

What is the solution for this issue? Is there any place where I can download the earlier version of MS Access?

Answer

Appetere picture Appetere · Apr 15, 2016

I've just used Excel 2016 to open Access 2003 tables.

  1. Open a new worksheet
  2. Go to Data tab
  3. Click on "From Access" menu item
  4. Select the database's .mdb file
  5. In the "Data Link Properties" box that opens, switch to the "Provider" tab
  6. Select the "Microsoft Jet 4.0 OLE DB Provider"
  7. Click on Next
  8. Reselect the database's .mdb file (it forgets it when you change Provider)
  9. Click OK
  10. From the Select Table dialogue that appears, choose the table you want to import.

Related questions

Combobox null in if statement

I am trying to code an if statement where if a certain combobox is null, then it runs a certain part of code if it has data in it then it runs another. I wrote up this: Private Sub ProjectAddSetDateAutoBtn_…

Read More
How to determine if a table contains a value in SQL?

I feel like I'm missing something very obvious here, but it seems that the only way to go about doing this is to get the value, and then see if it returns a null (empty) value, which I would rather …

Read More
Adding Trusted Location to Access Run Time

I have created a Microsoft Access file. How do I add this file to the trusted locations on my client's PC where there is only the runtime version of Access installed?

Read More