Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

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?

like image 685
Uma Ilango Avatar asked Jun 09 '14 08:06

Uma Ilango


People also ask

How do you fix Cannot open database created with a previous version of your application?

You can fix the error by converting the old database file format (. mdb) to the . accdb file format.

How do I open a previous version of an Access database?

On the Tools menu, click Database Utilities, click Convert Database, and then click to Access 2002-2003 file format. Enter a name for the database, and then click Save. Exit Access 2003. Open the database in Access 2013 or later version of Access.

Why is my Access database not opening?

If users are unable to open their ACCDB files in MS Access or encountering can't open Access database file then the most likely reason is a corruption of file. Corruption is a habitually recurring that can cause ACCDB file inaccessible. So it's important to restore data using a reliable third party tool.


2 Answers

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.
like image 96
Appetere Avatar answered Sep 29 '22 10:09

Appetere


You can use MDB Viewer Plus from http://www.alexnolan.net/software/mdb_viewer_plus.htm to view or edit your old version database

like image 21
Davros44 Avatar answered Sep 29 '22 09:09

Davros44