MS Access Multiuser - optimizing network performance

Author

optimizing network performance

Pierre

2005-04-12, 7:24 am

Hi all,

I want to ease the load on a network.

1. If i automatically close windows that are left open by user after an
amount ot time, is it going to help?

2. Is it true that a form with lots of object on it is a load on a network?

3. Is it true that using short names for database and link database will
make a difference in performance or
is it old stuff no longer true?

4. If i modify the size of long text fields (255) for shorter (40) will it
help knowing that all those fields are empty most of the time?

david epsom dot com dot au

2005-04-13, 8:24 pm

"Pierre" <pf@arobas.net> wrote in message
news:L2P6e.50007$_N4.1231689@wagner.videotron.net...
> Hi all,
>
> I want to ease the load on a network.
>
> 1. If i automatically close windows that are left open by user after an
> amount ot time, is it going to help?

Possibly. Open tables are refreshed by a background process.
If you don't have any windows open, they won't have any bound
tables open, and you may reduce the background traffic.

>
> 2. Is it true that a form with lots of object on it is a load on a
> network?

A form bound to lots of different tables loads the
network more than a form without those bindings.

>
> 3. Is it true that using short names for database and link database will
> make a difference in performance or
> is it old stuff no longer true?

It is /probably/ no longer true. What kind of network are
you using?

>
> 4. If i modify the size of long text fields (255) for shorter (40) will it
> help knowing that all those fields are empty most of the time?
>

No. It will have no effect except to stop you putting
longer strings into the field

(david)

Tony Toews

2005-04-19, 11:24 am

"Pierre" <pf@arobas.net> wrote:

>I want to ease the load on a network.

Are you having any specific performance problems?

The three most common performance problems in Access 2000 or newer
are:
- LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off

If the problem is for everyone when starting up the MDB then it likely
needs a decompile.

For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm
>
>1. If i automatically close windows that are left open by user after an
>amount ot time, is it going to help?

No.

>2. Is it true that a form with lots of object on it is a load on a network?

Of course. But sometimes you need to have a form with a number of
combo boxes, list boxes and subforms. That's life. But even then
there are some things you can do.

>3. Is it true that using short names for database and link database will
>make a difference in performance or
>is it old stuff no longer true?

Yes, this is still true but not that significant in 100 megabit
networks. Very true in slow networks such as dial up. Which you
shouldn't be running in Access anyhow.

>4. If i modify the size of long text fields (255) for shorter (40) will it
>help knowing that all those fields are empty most of the time?

No. Setting a different field size will make no difference in
performance. Access only uses what space it needs to anyhow.

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

Sponsored Links