Access application - very slow startup

[JF]

I have an Access application that takes a lot of time to start up. The
slowness occurs before any code is hit. Looking at task manager, I notice
that MSACCESS.EXE takes up 99% of the system resources and its memory
consumption slowly increases to a point. Finally after about 20-30 seconds
of this, the startup code executes.

I've tried compacting and repairing the database many times as well as
playing around with the references to no avail. Also, the application has
tables linked from MSDE, but I've deduced that the linked tables aren't a
problem because I've started the app with the MSDE service stopped and the
same problem occurs.

Any ideas what this could be?

Regards,

JF

 

[Sandra Daigle]

Take a look at the following article -
http://www.granite.ab.ca/access/performancefaq.htm

It will probably help you find several things in your application that can
be tuned to speed things up. For startup problems, I would make sure that
you don't have a virus scanner that is checking the network files, I'd also
make sure that Name Autocorrect is off. Regardless, be sure to read the
whole article - there are numerous things that you can tweak to improve
performance.

 

[PL]

JF posted the message below Dec 2003.

Has anyone found an answer to JFs posting yet (see end of
message below)? There was one response about tweaking
performance; but as far as I can tell this is not a
performance issue in the sense normally talked about by
MVPs. The delay is before any code is run, queries
excuted, tables connected. It simply takes forever for the
database window to appear. I have this problem for an app
with over 100 forms and 50 modules. I'm beginning to think
size is the issue.

Any clues anyone ?

PL

JFs posting :

I have an Access application that takes a lot of time to
start up. The
slowness occurs before any code is hit. Looking at task
manager, I notice
that MSACCESS.EXE takes up 99% of the system resources and
its memory
consumption slowly increases to a point. Finally after
about 20-30 seconds
of this, the startup code executes.

I've tried compacting and repairing the database many
times as well as
playing around with the references to no avail. Also, the
application has
tables linked from MSDE, but I've deduced that the linked
tables aren't a
problem because I've started the app with the MSDE service
stopped and the
same problem occurs.

Any ideas what this could be?

Regards,

JF

 

[Tony Toews]

The delay is before any code is run, queries
excuted, tables connected. It simply takes forever for the
database window to appear. I have this problem for an app
with over 100 forms and 50 modules. I'm beginning to think
size is the issue.

Nope. I have an app with 450 forms and 350 reports.

Very much sounds like a decompile will fix this one. Decompile or how
to reduce Microsoft Access MDB/MDE size and decrease start-up times
http://www.granite.ab.ca/access/decompile.htm

BTW just for my curiosity could you do a timing test before. I doubt
you'll need to do one after as it will be virtually instantaneous.
<smile> Also see how large the MDB is before and after.the
decompile.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm