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