General discussion

Locked

Access on a Server

By Ryan Proctor ·
Have Access on a server, assigned users are 164, max users at any one time is about 20, max users during a test is 47. My question is this, where is the point that Access 1: starts to slow down and 2: point of failure. There is plenty of memory (2.5G assigned) for the test, is there any experience out there with this sort of test?

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by dirtycar74 In reply to Access on a Server

I think that more information would help to provide a suitable answer. I believe that the number one thing to consider is the design of the database you are using; the more efficiently it is built, the less the database will show signs of slowing and the more data it can handle in a given time. My first suggestion would be to run the analyzer tool and see if Access suggests any design changes. Typically, a well-designed database in Access 2000+ can handle a very large amount of data and a significant number of concurrent users; but nothing is static, there are far too many things to consider separately - Hardware architecture, OS setup, RAM, etc... But like I said, typically, you should consider the complexity of the application and the way that it is designed.

Collapse -

by Ryan Proctor In reply to

All ready known, was looking for people that had similar issues and what they did to work around them

Collapse -

by Ryan Proctor In reply to Access on a Server

The Access database being run has 15 tables with 14 running off of a base table. The base table has 150 columns with over 273,000 rows. Yes that is correct and not a typo. The terminal server is running Windows Server 2000 SP 4 on a 2.8Ghz 3.8GB system. Hope this helps with your answer.

Collapse -

by Ryan Proctor In reply to Access on a Server

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums