Performance Getting better and regress again. WHY

[Chedva]

I had bad performance opening forms in AccessXp, Someone here wrote to me to
change all recordsource to be in the on load events. It helped nice but
after sometime (few times of opening the application) it regress again. What
to do??

 

[James Goodman]

Check out the Name AutoCorrect setting in Tools, Options, General. This can
make a big difference with form performance...

 

[Arvin Meyer]

I had bad performance opening forms in AccessXp, Someone here wrote to me to
change all recordsource to be in the on load events. It helped nice but
after sometime (few times of opening the application) it regress again. What
to do??

Make sure that Track name AutoCorrect is off

Turn off sub datasheet Name property by setting [Auto] to [None]

Try making a persistent connection to the back-end. You can use a bound form
which is always open to accomplish this.

I use a dummy table with 1 record. Open a form during startup which is
hidden and bound to that table.

Have a look at Tony Toews performance faq to reduce some of the issues you
are seeing:

http://www.granite.ab.ca/access/performancefaq.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Tony Toews]

Someone here wrote to me to
change all recordsource to be in the on load events.

That's a rather unusual suggestion.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm