Slow Access Start-up

[Philip A Leicester]

Over the past year, as my application has been further
developed, I've
noticed it has got incredibly slow just to get to the
database window.

I enter my name and password, then it can take a minute or
five before the database window appears. Users, for whom
an autoexec runs, experience a similar delay. This is
frustrating them!

Why is this? What is Access doing during this period.

To give you some idea of the app, is a large with 50 so
code modules or
classes, 50 or so forms, all with CBF.

How can I speed this up?

 

[gandalf]

Have a surf to

http://www.granite.ab.ca/access/corruptmdbs.htm
http://www.able-consulting.com/ado_conn.htm
http://www.mvps.org/access/api/api0001.htm
http://members.rogers.com/douglas.j.steele/AccessReference
http://www.mvps.org/access/tables/tbl0009.htm
http://accdevel.tripod.com
http://www.lebans.com/mousewheelonoff.htm
http://www.trigeminal.com/usenet/usenet001.asp?1033

most sites have a performance-hints page

What version of Access are we talking about? Is the
application split in a front-& backend.
Can it be fully compiled?
In case of Access 2000 & higher, is the autocorrect
feature off + making sure you have a persistent connection
to the backend?
Is your design normalized & do your tables have proper
indexes?
Networkspeed?
Is it a full Access-environment or do you connect to
another odbc-source?