Converting Access 2000 to Access 2007

Posted on 2011-10-31
Last Modified: 2012-05-12

I have been given an Access database with multiple forms and queries.
Is it possible to convewrt all or part of this to Access 2007?

Question by:murbro
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    Well it's generally either all or nothing, you can open the DB in Access 2007 and select "Save As" the 2007 (.accdb) format.

    Not that you should generally only convert:
    1. when you are sure that no user with Access 2003 or older will ever need access to the DB
    2. You need some specific feature in Access 2007
    LVL 74

    Accepted Solution

    Open the db in Access 2007
    Office Button
    Save As
    Access 2007 Database

    Author Closing Comment

    thanks very much for the help

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    755 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

    24 Experts available now in Live!

    Get 1:1 Help Now