Database very slow

[SF]

Hi

I have a back end database of about 6MB in size put on a share network
drive. A front end has been developed and distribute on each user desktop. I
notice that the performance of the front end is slow. Same setting put on a
sub office in other province work better. In the share drive (O there are
about 50,000 files. Could this be the reason for the slowness?

SF

 

[Albert D.Kallal]

The #1 tip is keep a persistent connection open at all times (that just
means to open a table in your startup code in the front end to the back
end...any table will work - you need to FORCE the connection to stay open,
and this reduces a large delay).

Try the above....you will be pleasantly surprised.

The above tip can be found in the following great list

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

Work your way thought the above list. And, remember to distribute a mde for
the front end....

 

[Tony Toews]

Same setting put on a
sub office in other province work better

Quite possibly because there was only one user on at that time. If
two users were in the FE accessing the BE then you'd likely have the
same slowdown.

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