MS Access: Number of active users

~J~

~J~

Soldato
Joined
20 Oct 2003
Posts
7,558
Location
London
Quick question.

If I have a very basic MS Access database on a network share, is there a limit on how many users can access the database at once, or in the least, a number of active users where the database could potentially become unreliable?
 
TBH, it's actually a bit of 'fact' for a client of mine. They've got an Access database on a server which is been accessed by about 100 people on a factory floor ( :eek: ), and I've been trying to find a reliable website that would either confirm or hint towards the fact that this is, er, a bit dangerous to say the least.

I'm sure I read years ago that MS-Access 97 could only have about 10 users accessing the data at once before record-locks or 'maximum number of user' errors started to occur, but they're using Access 2003 which doesn't seem to have a maximum user issue as such, but technically isn't wise to do.
 
sfx said:
100 people at once my arse...

There is a 15-20 connection limit on access... Any more than that and it will be moaning at you.

sfx

Well I can't tell that "my arse" can I? :p

Any ideas where I can find out this, I've been checking a few sites and can't seem to see the magi 15-20 figure.
 
Back
Top Bottom