Fast loading form in MDE, slow in MDB

  • Thread starter Thread starter GGiusti
  • Start date Start date
G

GGiusti

Hi,

My problem: a form uses few seconds to open in a MDE file but uses
60/90 seconds to open in a MDB file.
The MDB has been compiled and compressed, but it still takes a lot of
time to load.

Thanks in advance
 
My problem: a form uses few seconds to open in a MDE file but uses
60/90 seconds to open in a MDB file.
The MDB has been compiled and compressed, but it still takes a lot of
time to load.
Click to expand...

I suspect this is the AutoCorrect problem.

The three most common performance problems in Access 2000 or newer
are:
- LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off

For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

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