Running Access 2003 retail on Access 2007 Runtime on the same system

Posted on 2009-04-20
Last Modified: 2013-11-29
I created an Access DB project in Access 2007.  The server in our office has Access 2003 but upgrading to 2007 requires that we purchase multiple copies for multiple seats so this got a little expensive.  

I installed the 2007 runtime version on the server, changed the extension to .accdr and the program worked great, but none of the 2003 access DB's would work, because they were opening with the 2007 runtime.  I right clicked on the 2003 version and told it to open with Access.  This fixed the problem with the 2003 versions, but it set the default to open with the 2003 version, and I can't open the 2007 runtime program.

Is there any way to make the computer open the .mdb program with Access 2003 and the .accdr versions with the Access 2007 run time version.

I have searched extensively online but I can't find any information.  

I would appreciate any ideas that you may have to resolve this.
Question by:rockymtnAccess
    LVL 23

    Accepted Solution

    Try This:
    Uninstall Access 2003 then reinstall access 2007 runtime.
    Reboot then install Access 2003 and install all the serivce packs.
    Access should take over the .MDB file and leave the .ACCDR alone.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Try running your Files from shortcuts that specify the Access executable to be used to open the file:

    The command of the shortcut would be something like this thje attached snippet.
    The snippet will force the Database file named: YourDatabase.mdb be opened with Access 2003
    (Obviously you will need to reference your specific Office Folder location)


    "C:\Program Files\Microsoft Office 2003\OFFICE11\MsAccess.exe" "c:\YourFolder\YourDatabase.mdb"

    Open in new window


    Author Closing Comment

    I installed the service packs for Access 2003 and that resolved the issue.   I did not need to uninstall/reinstall anything.  There is a delay every time you switch from 2003 to 2007 of about 2 minutes, but it works.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Know what services you can and cannot, should and should not combine on your server.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    754 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

    20 Experts available now in Live!

    Get 1:1 Help Now