[AccessD] Slow Forms

Reuben,

<<Everything worked very quickly until I compacted and repaired the db.
After
compacting, this form will open slowly one time and then open quickly all
other times.  It will continue to open as I would expect it to until it is
compacted again.>>

  Not sure what you mean by "slow" (i.e. drastic difference?), but you will
in general see that after any compact as the database stats are reset and
all query plans are redone the first time a query is executed.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Reuben
Cummings
Sent: Tuesday, March 30, 2004 4:15 PM
To: AccessD
Subject: [AccessD] Slow Forms


I need help with a form that opens very slowly.

Everything worked very quickly until I compacted and repaired the db.  After
compacting, this form will open slowly one time and then open quickly all
other times.  It will continue to open as I would expect it to until it is
compacted again.

However, if the app is made into an mde then it always opens slowly.

The form is based on a query.  There is a tab control on it.  One tab has
about 14 fields from the same recordsource as the main form.  The other
three tabs all have subforms based on queries.  2 of those queries have
fields that call functions to get their value.

All the queries and subforms open very quickly.  And if I delete the
subforms, the main form will always operate quickly.

I have imported into new db's.  I have completely rebuilt the main form.

Any suggestions on where to start troubleshooting this thing?

Thanks.

Reuben Cummings
GFC, LLC
phone: 812.523.1017
email: reuben at gfconsultants.com



--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com