Access 2003 forms VERY SLOW when opened in prior versions

Posted on 2004-11-03
Last Modified: 2008-12-14
I have an interesting phenomenon that is occurring.

I have Access 2003 installed on my machine, and most of my clients are using Access 2000 or Access 2002. If I take an existing database that was created in a version of Access prior to 2003, and either update forms/reports or create new forms/reports in 2003, when I attempt to open them again in the prior version of Access (i.e. on my client's machine/server) their performance is severely compromised. They run extremely slowly, particularly to open the form. The same form/report when run in 2003 works quite quickly, and if I re-design it in the prior version of Access, it runs OK on the old version, too.

I am using quite a bit of code under my forms.

I have searched the Microsoft website, and was unable to find any documentation on why this was occurring, and was wondering if anyone had any input on what the problem was? or if anyone else has experienced this, and had a solution as to how to fix it. This is a bit challenging, as all of the things I design are ultimately NOT going to be used on my machine, but I LOVE the new design features in 2003.


PS: Please try to refrain from blatant Microsoft bashing -- I know, it's difficult --, as this is what I  use, and know, and I really like it.
Question by:VeeVan
    LVL 18

    Assisted Solution

    1.  Try the decompile switch.  Create a shortcut to your database and use /decompile at the end.  When the database opens confirm that you have no missing references and then perform a compile and then click the save icon on the tool bar.

    2.  I would also perform a compact and Repair.  

    3.  You might also try importing all objects into a clean database.  Don't forget to set any references.

    LVL 2

    Accepted Solution

    I had a similar problem. The following helped a lot:

    Tools/Options/General    Uncheck "Track name AutoCorrect info"

    Hope that helps

    LVL 1

    Author Comment

    I'll try both of those and get back to you.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    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.

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
    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 …

    737 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