Need Info On Number Of Users Access Can Support 2

[drosenkranz]

I'm having discussions with administrators here over capabilities and limitations of Access. I know this a very general question but I need some feedback on what others have found. I've had as many as 40 users in a VB system that has about 30 Access tables. The database is over 120 meg. There are 3 main tables and the rest either linked in relationships or just serving as look-up tables for acceptable values or used to fill pull down boxes on VB forms. Any input appreciated on limitations on the number of Access users would be especially helpful.
The 2nd mouse gets the cheese.

 

[link9]

I have heard that the theoretical limit of Access is somewhere around 150 users, but I have NEVER been able to get that level of performance out of it.

You should tell the people that you are discussing this with that if you are asking this question, then there is a very good chance (in the neighborhood of 100%) that you should move to an enterprise scale DBMS. You will be happier... they will be happier... users will be happier... Everyone is happy and Advil consumption is way down.

good luck!
Paul Prewett

 

[edderic]

>>Generally speaking, if you get anything over around 10 users in Access
>>your
>>performance starts going to lunch very quickly - and there's a lot of
>>related
>>that starts happening as well.

which is about right. So 25 users at once is going to be stretching things
more
than Access can handle, probably.

As for another DB, I wouldn't go with oracle as the investment of time/money
etc would be prohibitive for such a small project. SQL server would be my
choice, it would very comfortably handle the task and is of course scalable.
You can get a 100+ day evaluation copy to let you play before splashing out
any cash. Also you could get away with using version 6.5 which will cost
less than version 7 or 2000 etc. I'm not sure your school would need all the
bells and whistles available in the more recent versions.
Eric De Decker
vbg.be@vbgroup.nl

License And Copy Protection AxtiveX.

Download Demo version on my Site:

http://www.createsoftware2000.com

 

[chiph]

drosenkranz -

Do like Eric says and get a copy of SQL server. You probably don't need the Enterprise edition, which will save you a ton of money.


The 2nd mouse gets the cheese.

:-0 The cheese book strikes again!

Chip H.