Access Runs Slow With Multiple Users

[Nick hfrupn]

I have an Access 200 database on a server that only stores the data. This is
used by 5 other people from their own database on their PC that has linked
tables to the one on the server. By the time the last person connects Access
is almost unusable because it is too slow.
Is there any way I can improve the sharing capabilities to improve the speed?
Is replication of the database on the server an option and getting the other
user to link to a replica?

Any help will be appreciated.

Regards
Nick

 

[Tom Wickerath]

Hi Nick,

Have a look at this article:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html

The four most important things you can do are:

1.) Disable Name Autocorrect
2.) Set all sub-datasheets to [None]
3.) Split the database, giving each user their own copy of the FE
application and
4.) Establish a permanent connection


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Tony Toews]

I have an Access 200 database on a server that only stores the data. This is
used by 5 other people from their own database on their PC that has linked
tables to the one on the server. By the time the last person connects Access
is almost unusable because it is too slow.

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

 

[Arvin Meyer [MVP]]

We now have 53 concurrent users on my system, and there is little decrease
in performance. We typically look at/edit 2 to 300 records and it takes
under a half second to load them (out of a table with 80,000 or more
records).

To do that, in addition to the already good answers that you've received,
remember to index all key and search fields and open forms without any
records, then use one or more combo and list boxes to fill the data in the
form. That reduces table scans to just the records you need.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access