Open MS Access 2003 mdb from MS Access 2000

Posted on 2007-10-01
Last Modified: 2008-03-15
I have MS Access 2000 on my machine . I have around 40 applications running in Access 2000 on my machine

My client has sent me an MS Access 2003 mdb file
I am unable to open that file from MS Access 2000

I am getting an error that my database is of a lower version and needs to be upgraded .
Can I open MS 2003 database on my machine without re installing MS 2003 on my machine.

I do not want to jeopardise the other 40 applications on my machine which are running on MS Access 2000

Is there some other alternative . Please suggest.
Question by:vsuripeddi
    LVL 65

    Accepted Solution

    >My client has sent me an MS Access 2003 mdb file ... I am unable to open that file from MS Access 2000
    Correct.  This is by design.  

    Your ownly real choices here are to either find an A2003 box, open the file, downgrade it to A2K, or ask the client to do it for you.
    LVL 1

    Expert Comment

    One possible solution is to create a access run-time of your access2003 mdb file/application. See this link for more information:
    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    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.

    Join & Write a Comment

    Suggested Solutions

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    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 Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    734 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

    23 Experts available now in Live!

    Get 1:1 Help Now