[AccessD] Slow Forms

Reuben - This worked for me once:

1) Comment out ALL code in the form.  Save the form.

2) Exit out of the db.

3) Decompile while opening the db.

4) Uncomment all the code behind the form.

5) Compile the db.


Any better?  

I believe that commenting out all the code, then decompiling the db, removes
all compiled code behind the form.  When you uncomment the code and compile,
now the compiled code is all new.  This gives the form a 'fresh start'.  I
have no basis for this idea, but it did help once with a form that was
crashing, and after I did this, things went faster!

Best of Luck!
Dan




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Reuben Cummings
Sent: Tuesday, March 30, 2004 3: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