Changes to form causes slow opening

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M Skabialka - 28 Feb 2006 14:01 GMT

I have a form which opens very quickly, unless I make any changes to it.
Then it takes 10 - 15 seconds to open. Even such a small change as moving
the field around. I tried making a blank new form, copying the fields and
VBA code and this form will also be slow to open. I have decompiled and
recompiled the databases (FE/BE) more than once. The fields all come from
one table, a combo to select the current record, a couple of combos drawing
from very small tables to validate entry data, and 3 buttons to open other
forms.

What might be the problem here? Other forms and reports in this Access 2000
database work fine.

Thanks,
Mich

Reply to this Message

Allen Browne - 28 Feb 2006 14:44 GMT

Make sure the Name AutoCorrect boxes are unchecked under:
Tools | Options | General
Explanation of why:
http://allenbrowne.com/bug-03.html

If the tables are attached, make sure the SubdatasheetName property is set
to [None]. More about that and other issues:
http://www.granite.ab.ca/access/performancefaq.htm

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a form which opens very quickly, unless I make any changes to it.
>Then it takes 10 - 15 seconds to open. Even such a small change as moving
[quoted text clipped - 10 lines]
> Thanks,
> Mich

Reply to this Message

M Skabialka - 28 Feb 2006 17:12 GMT

The first option speeded it up a little, the second made it open
immediately!

Thanks so much!
Mich

> Make sure the Name AutoCorrect boxes are unchecked under:
> Tools | Options | General
[quoted text clipped - 19 lines]
>> Thanks,
>> Mich

Reply to this Message