Performance Getting better and regress again. WHY

  • Thread starter Thread starter Chedva
  • Start date Start date
C

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??
 
Check out the Name AutoCorrect setting in Tools, Options, General. This can
make a big difference with form performance...
 
Chedva said:
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??
Click to expand...

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
 
Chedva said:
Someone here wrote to me to
change all recordsource to be in the on load events.
Click to expand...

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
 
Back
Top