Solved

Access 2007 Backwards Compatibility

Posted on 2009-07-07
1
249 Views
Last Modified: 2013-11-29
I have been issued a laptop that has MS Office 2003 Standard loaded on it. I am looking to load MS Access to this laptop and assume that the best decision is to load Access 2007. Is Access 2007 backwards compatible with databases I created in Access 2002 and 2003?
0
Comment
Question by:Ennistymon
1 Comment
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 50 total points
ID: 24800169
Ennistymon said:
>>I am looking to load MS Access to this laptop and assume that the best decision is to load Access 2007.

That depends.  If you are going to be working with Sharepoint also, then this may be true.  If not, you
may want to pause.

>>Is Access 2007 backwards compatible with databases I created in Access 2002 and 2003?

Yes and no.  Access 2007 can open files created in A2000, A2002, and A2003.  However, if you create
a file in the new accdb format, earlier versions cannot read it.

You can create a new file in A2007, and save it as a MDB using either the A2000 or A2002/2003 file
type, and the earlier versions of Access should open those.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
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…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

896 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

17 Experts available now in Live!

Get 1:1 Help Now