Slow Loading Forms

[Jim Bunton]

Access 2000, Windows 2k

I've got some fairly complex forms in a front end database
When they are used they load very slowly
All code has been debug > compiled
Database has been repaired and Compacted

They still run slowly!!

BUT
If I do a rebuild by creating a new database then dragging everything into
it and relinking all the required tables the forms load very quickly.

IS THIS NORMAL ?
IS THERE A WAY TO ACHIEVE THE SAME RESULT WITHOUT DOING A REBUILD?

 

[Albert D.Kallal]

This behaviors is usually the result of having track-name autocorrect.

Further, another trick is to ALWAYS keep a persistent connection form the FE
to the BE.

Do both of the above..and performance will get even better.

You can learn the above two tricks, and whole bunch more of thing to check
here:

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

 

[Jim Bunton]

Thanks for the reply Albert - Looks like the biz but today is Saturday - mow
the lawn etc - so I'll look at the details first thing Monday

Jim