Re: Incredibly Slow Form Load - now

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 09:37:45 +0800

The A2000 format is not the problem.

It could be several things, such as Name AutoCorrect, Subdatasheets, linked
tables where the path is more than 128 characters, etc.

Tony Toews has a full list in:
    The Access Performace FAQ
at:
    http://www.granite.ab.ca/access/performancefaq.htm 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Allan" <newsTAKE.OUT@TAKE_OUTcomunity.net> wrote in message
news:7Om4d.33175$yW6.16295@clgrps12...
>I build a business critical contact database in Access 2000.
> We have installed Access 2003 several months ago.
>
> In the past couple of weeks, the database has really slowed down!
> Today it is barely loading (3+ minutes to load the forms when open the
> app)...
>
> I have tried compacting the database, and helped a bit. Is this typical? 
> Is
> there some known thing I could do to improve its performance.
> There is one table, that logs phone calls, that is just over 1300 records,
> so it can't be that.
> It IS still Access 2000 format. Is that a problem?
>
> Any suggestions? There is essentially no performance on this. Pull down
> menus take a long time too!
Loading