Slowwww database

[Shawn]

I have a Access database (Access 2000, 100 tables, 170+
queries, 100+ forms, and 100+ macros ) running on a
Windows 2000 Server network. When users boot their pc's, a
log in script brings a copy of the front end to their
local C: drive.

I have a copy of the front and back end on a test network
and almost ready to go live with it. My problem is
performance. Instead of a 5 second lapse to open a form it
is now 45-60 seconds to open the same form.

What exactly causes this decrease in performance? The
encryption? Possibly the filters on permissions? Is this
database just too big to effectively run security? Any
help is greatly appreciated. Shawn

 

[Cheryl Fischer]

You might want to check out the performance tips collected by Access MVP
Tony Toews:

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

 

[Shu]

Thank you Cheryl! I tried the easiest and most obvious
trick. I unchecked the "Perform name AutoCorrect"
and "Track name AutoCorrect info" checkboxes in
Tools>Options>General in the Name AutoCorrect section.
Five clicks of the mouse decreased the open form delay
from 30 seconds down to 5, almost what it originally was.
Can't thank you enough!

Shu (Shawn)