Converting Access 2010 tables to 2007

Posted on 2014-08-21
Last Modified: 2014-08-21
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
Question by:data-informatique
    1 Comment
    LVL 30

    Accepted 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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now