Slow form

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Denis (anonymous_at_discussions.microsoft.com)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 10:19:51 -0700

Hi,

I've recently inherited a DB which was built by somebody
else. One of the forms takes about 2 minutes to open. It
is a form with about 7 tabs, each tab with a couple of sub-
forms. The query driving the form includes 6 tables, but
the query opens up in about 2 secs. The form has a lot of
VBA code controling the Visible property of various
controls.

To speed the form up, I have:
1. split the database so that front ends sit on users
machines
2. set referential integrity on the back end database
(yeah, it was built without referential integrity!)
3. deleted 5 of the tabs, to clean things up, and created
buttons leading to other forms.

The form still takes about 40 secs to open. Could it be
because the first tab includes a couple of sub forms and
filters (combo boxes)? Any ideas to speed this thing up
further?

Thanks!

Denis

Quantcast