MS Access Multiuser - Painfully slow network performance

Author

Painfully slow network performance

Jeff Stroope

2005-05-27, 11:24 am

Hi,

I have an Access database application that resides on a network file server.
The application uses the TransferSpreadsheet method to populate Excel
workbooks with query results. There are 13 queries and 13 workbooks. The
application then opens one of 27 Word documents based on the users choice in
an option group on an Access form. The Word docs have one big table and the
table cells are linked to cells in the various spreadsheets. When I work on
the database, I copy it to my desktop because it's so slow on the network.
There are only 4 users, all in different company locations and I don't know
where the server is physically located. I've tried splitting and replicating
the database - following the instructions in "The Complete Reference - Access
2000 - with no perceptable improvement in performance. Does anyone have any
suggestions on how to increase the speed of the network database?

Thanks,

Jeff Stroope

Tony Toews

2005-05-27, 1:24 pm

Jeff Stroope < JeffStroope@discussi
ons.microsoft.com> wrote:

>I have an Access database application that resides on a network file server.
> The application uses the TransferSpreadsheet method to populate Excel
>workbooks with query results. There are 13 queries and 13 workbooks. The
>application then opens one of 27 Word documents based on the users choice in
>an option group on an Access form. The Word docs have one big table and the
>table cells are linked to cells in the various spreadsheets. When I work on
>the database, I copy it to my desktop because it's so slow on the network.
>There are only 4 users, all in different company locations and I don't know
>where the server is physically located. I've tried splitting and replicating
>the database - following the instructions in "The Complete Reference - Access
>2000 - with no perceptable improvement in performance. Does anyone have any
>suggestions on how to increase the speed of the network database?

I don't mention anything about Word or Excel documents in my
performance FAQ. And you may have trouble getting much help with
Word or Excel performance problems. So for Access only performance
issues only see the following.

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

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