[AccessD] Performance tips anyone?

John,
My comments in line:

 Errrrr!  Wrong answer.

I have a database with 25 users in the database every day.  The BE is
currently about 800 mbytes.  This BE has tables with hundreds of thousands
of records in some tables, 30K-50K records in the main tables (claimant /
claim).  I open a VERY complex tabbed form with about 20 tabs on it, with
subforms on each tab (JIT subforms).
***************************************
You are very brave
***************************************
I open a VERY complex tabbed form with about 20 tabs on it, with
subforms on each tab (JIT subforms).

Users on fast machines open the form in about 1.2 seconds.  Users on very
old slow machines take about 5 to 6 seconds.
***************************************
A form will open fast if designed well.
***************************************

Speed of the individual workstation is the single largest determinate of
acceptable speed.  A high speed processor and LOTS of memory (1 gig for
Windows XP Pro) are essential.  Moving to a 1 gbit lan made a big difference
as well (which requires a gigabit NIC in the machines as well).
***************************************
You can keep throwing hardware at Access applications to will make them
perform faster. The real trick is to get your database to perform fast
regardless.
***************************************

Anita