Open msaccess2003 db from win7 environment in xp environment

Posted on 2012-09-10
Last Modified: 2012-09-10
I am running win7 (64 bit) on one computer and have ms access2010. There I have converted a db into access2003 format to open with access2003 on another computer that runs on winxp.

The saving of the db in access2003 format work fine. But cannot open the db in the xp/access2003 computer. I receive an error message that error occurred and db has to be closed.

if I open db with pressed shift the db opens but cannot open some forms. As I understood reason could be related that some libraries in the db are from win7/msa2010 environment.

I managed to open one form by changing in design mode some library settings in the references using trial and error. But there are some other forms which I did not manage to handle and I am not knowleageable enough to sort this out.

Does this problem make sense and is there a simple way to get the converted db working in the winxp/msa2003 environment?

Thanks for the support.
Question by:vamav
    LVL 119

    Expert Comment

    by:Rey Obrero
    <There I have converted a db into access2003 format to open with access2003 on another computer that runs on winxp. >

    sad to say but, there is no backward compatibility in access 2010 to access 2003.

    you can try creating (not converting) a .mdb in access 2010 and if you don't use a feature in a2010 that does not exists in a2003, you might be able to run the db in A2003.

    developing a mixed version of access is preferably done in the lowest version of access (access 2003 ) in this case.

    Author Comment

    Thanks for the hint.
    In the db I have, I do not use any msa2003 features.
    What I did now is to create a new db with msa2003 on other xp computer and then imported the converted db into it. This worked but it gave some error message about some module. I then deactivated a reference in references in design mode of the main form and then it worked fine.
    However I as I was going by trial and error I simply do not remember which one I deactivated.
    Have you go an idea or a link which shows what entries in references should be active in msa2003?
    LVL 119

    Accepted Solution

    open the db in A2003, open the vba window then open the references

    tools > references

    look for references with MISSING prefix
    remember what reference it is,
    uncheck the reference and locate the available reference, it will be the same name but different version numbers.
    select the reference and click ok.

    finally do a Debug >compile
    make sure to clear any errors raised

    Author Closing Comment

    Thanks it worked!

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
    This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…
    This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…

    746 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

    13 Experts available now in Live!

    Get 1:1 Help Now