Performance Issues - Access 2000

[David]

I have recently split my database into a back end on a
network drive and front end on each users personal drive,
and have found it very slow when opening forms and certain
queries. Strangely though a few days after I have setup
the front end on the users personal drive it speeds up?
Does anyone know why this is or have any tips on
increasing performance. thks

 

[Joseph Meehan]

I have recently split my database into a back end on a
network drive and front end on each users personal drive,
and have found it very slow when opening forms and certain
queries. Strangely though a few days after I have setup
the front end on the users personal drive it speeds up?
Does anyone know why this is or have any tips on
increasing performance. thks

There are lots of tricks to speed up the process. I suspect the speed
increase you have noted is a result of a change to the Network not Access.
BTW are those queries and forms on the BE of FE?

 

[Guest]

I thought it could be network related, just looking for
someway of compensating for this. All the forms and
queries are on the front end.

 

[miTch]

http://www.ostrosoft.com/smtp_component.asp

 

[Tom Wickerath]

Hi David,

There are several things that you should check out when converting a single-user application to
multi-user. First, you should make sure to disable NameAutocorrect and set subdatasheets to
[None] in all of your tables:

http://support.microsoft.com/?id=290181

http://support.microsoft.com/?id=275085

http://members.iinet.net.au/~allenbrowne/bug-03.html

It is very helpful to keep a persistent connection open, make sure that the path to the shared
folder is as short as possible and other various tips:
http://www.granite.ab.ca/access/performanceldblocking.htm

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

http://support.microsoft.com/?id=891176

Make sure to apply proper indexes to fields that you use as criteria in queries or that you base
sorting upon. Do any of the forms that are slow to open have combo boxes with a huge amount of
records? If so, you might want to implement code that delays populating the combo box:
http://msdn.microsoft.com/library/d.../en-us/dnacbk02/html/ODC_CookbookChapter8.asp

Do any of the forms that are slow to open have subforms with lots of records? If so, you might
want to implement the tab on demand idea:
http://www.fmsinc.com/free/tips.html#accesslatebind

When you work your way through all of the above, let us know if you are still struggling with
slow performance.

Tom
_____________________________________


I have recently split my database into a back end on a
network drive and front end on each users personal drive,
and have found it very slow when opening forms and certain
queries. Strangely though a few days after I have setup
the front end on the users personal drive it speeds up?
Does anyone know why this is or have any tips on
increasing performance. thks

 

[Steve Huff]

The following KB article recommends not using long file names when linking
the BE tables.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;891176

 

[Tony Toews]

The following KB article recommends not using long file names when linking
the BE tables.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;891176

Ah, so MS finally made that official. Thanks for posting.

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