Performance lag

Josh · Dec 16, 2003

I did two things with my MS Access 2002 app:
1) Opened the ADO library (so that both ADO and DAO are
active). I think I have disambiguated everything.
2) Made lots of field name changes in forms and reports.
It is running extremely slow now.
How would you diagnose the problem or address the issue?
Thanks for any help.
Josh

Sandra Daigle · Dec 16, 2003

Hi Josh,

First make sure that you have disabled the Name Autocorrect feature - it
causes a huge performance hit. (Tools->Options, under the General tab
uncheck 'track name auto correct information'). Compact, close and reopen
the database. For other performance related issues see the following:

http://www.granite.ab.ca/access/performancefaq.htm

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q300216
Keep a Jet 4.0 Database in Top Working Condition

Performance lag

Josh

Sandra Daigle