Groups > comp.databases.ms-access > #10391

Re: Slow Database(s)

From	"Albert D. Kallal" <PleaseNOSpamkallal@msn.com>
Newsgroups	comp.databases.ms-access
References	<c6bcd8ee-6080-4eae-be55-0b1eaf167ca0@googlegroups.com>
Subject	Re: Slow Database(s)
Message-ID	<fISFw.48$BJ.39@fx30.iad> (permalink)
Date	2015-02-20 20:12 -0700

Show all headers | View raw

"BrianDP"  wrote in message 
news:c6bcd8ee-6080-4eae-be55-0b1eaf167ca0@googlegroups.com...

>I had resigned myself to the slowness of my computer, databases, or 
>whatever it is.
>It can take upwards of 20 seconds to switch from "view" to design

I am not aware of ANY version of Access when working on say a "typical" 
application with 160+ forms, 200+ reports and well over 40,000 lines of VBA 
code.

The switch between design and view is VERY short.

if you are experience a delay, then something is VERY wrong!

The above is in fact great news - because it means you should peruse and fix 
this issue.

Removing some old junk might save you .001 (one thousand of a second).

So a few things:

If you database is split, then open a linked table (any linked table to the 
back end). Now try working and developing on one of those slow forms - the 
delay in switching should go away.

The idea that switching should take more then say 1 second means something 
is VERY wrong here.

Check for reports or a default printer that points to a non existing network 
printer.

work you way thought the following list:

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

MAKE sure you work with a persistent connection if this is split.

I suggest setting your default printer to a LOCAL printer - even if it a 
free PDF writer.
Do NOT work with a default printer as network, or one that is NOT connected.

And if you have virus software - disable that during the above steps and 
testing.

The experience of the "general" Access community is NOT what you are 
experience and this slow form issue can and should be addressed.

Good luck! - and do follow up if none of the above fixes your issues.

Regards,

-- 
Albert D. Kallal  (Access MVP)
Edmonton, Alberta Canada
PleaseNoSpam_kallal@msn.com

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Slow Database(s) BrianDP <bdp222@gmail.com> - 2014-11-20 09:32 -0800
  Re: Slow Database(s) Patrick Finucane <patrickfinucanetx@gmail.com> - 2014-11-20 10:50 -0800
    Re: Slow Database(s) BrianDP <bdp222@gmail.com> - 2015-02-20 06:59 -0800
      Re: Slow Database(s) Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-02-20 07:51 -0800
  Re: Slow Database(s) "Albert D. Kallal" <PleaseNOSpamkallal@msn.com> - 2015-02-20 20:12 -0700

csiph-web