[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 453
  • Last Modified:

Converting Access 2010 tables to 2007

I am attempting to convert a database from Access 2010 to 2007.  I was able to convert the front end by creating a blank Access 2007 database and importing the various forms into it, however, the same cannot be done for the back end.  I tried the following:
- creating a blank 2007 database and importing the tables but I get "unrecognized format"
- creating a blank 2007 database and exporting the tables to it but I don't even see the test 2007 access database

Any idea would be greatly appreciated
1 Solution
Try the new database as mdb type.
Import the tables, and this will not import fields specific for newer access.

You then may import the objects to a new accdb file.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now