Access 2002 slow in design mode.

[Michel S.]

Hi !

I currently working on a simple Access (2002) database, all self
contained (no linked files) and located on my C: drive.

I find the overall performance in design mode is sometimes very slow,
and I'm wondering how it can be improved.

For example, if I click on a control on the toolbox and then click on
the form and drag the mouse, it can take 10 to 15 seconds before I can
actually see the control's rectangle area. If I then press the "Del"
key, it's another 5 to 10 seconds before it disappears from the form.

In the VBA editor, if I click on the scrollbar to browse thru the code,
it sometimes takes 3-4 seconds before the next page is displayed.

I searched on the newgroups and found a couple of suggestions (ex:
uncheck "Track Name autocorrect Info" in General Options) that I
followed. I also took advice from the
http://www.granite.ab.ca.access/performancefaq.htp page, but few of
them related to my project, which is quite simple so far (5 forms, 6
tables).

In addition, as I said earlier, everything (including my office
programs) is on my C: drive which is freshly defragmented.

My computer is a P4-2.4ghz, 512Mb RAM, 80Gb WD Caviar HDD

Aside the obvious, (ie: avast antivirus), no other application is
running at the same time.


Are others experiencing this lack of performance ?

Any advice ?

Thanks..

 

[Guest]

Durn. You already hit my first pick: Name AutoCorrect.

Next I'd temporarily turn off the anti-virus and see if it runs faster.
Often you can exclude certain types of files such as .md*

Run the anti-virus with the most recent updates just to be sure.

Run a spyware program - or two! - to make sure something isn't slowing the
computer down.

Make a complete backup of the database. Do a Ctrl + g. Go up to Debug and
Compile. Fix what is broken and compile again. Then do a compact and repair.

Also make sure that you don't have something using a timer event in a hidden
form.

 

[Albert D. Kallal]

check your default printer...if it is a network printer, then change it...or
simply install a pdf printer (my default printer is a pdf printer, and this
gets rid of any problem of trying to communicate over the network to
a printer that don't exist).

I use the free pdf printer from here...


http://www.acrosoftware.com/products/cutepdf/Printer.asp

 

[Michel S.]

You are my hero -- it is now much much more responsive !

Thanks !


Dans son message précédent, Albert D. Kallal a écrit :

 

[dbahooker]

Jerry

maybe if you learned ADP and SQL Server you wouldn't make your
customers choose between light cheap and strong. I build all 3 without
a problem.

-aaron