Max 5 Simultaneous Users of a Database?

[David Portwood]

In his book "Access VBA Programming for Dummies", page 299, author Alan
Simpson discusses splitting a database into a front end and a back end to
enable simultaneous use. The front end is then distributed to each user "up
to a maximum of five simultaneous users". This seems a very low maximum -
probably not one that I can live with. Is it accurate? Any advice or
suggestions in this regard?

 

[Rick Brandt]

In his book "Access VBA Programming for Dummies", page 299, author
Alan Simpson discusses splitting a database into a front end and a
back end to enable simultaneous use. The front end is then
distributed to each user "up to a maximum of five simultaneous
users". This seems a very low maximum - probably not one that I can
live with. Is it accurate? Any advice or suggestions in this regard?

255 (theoretically) not 5. Actual practical limits depend on your network, the
design of the app, and what users are doing. A few dozen though is not unusual
at all and when all factors are just right over a hundred is doable.

 

[Guest]

Hi David,

It's certainly not the maximum number. Perhaps it is that author's opinion
of how many concurrent users you should have.

I have worked on systems that have had 30 concurrent users...

Hope that helps.

Damian.

 

[David Portwood]

Thanks for the quick reply, Rick. I was worried about this one.

 

[Dirk Goldgar]

In

In his book "Access VBA Programming for Dummies", page 299, author
Alan Simpson discusses splitting a database into a front end and a
back end to enable simultaneous use. The front end is then
distributed to each user "up to a maximum of five simultaneous
users". This seems a very low maximum - probably not one that I can
live with. Is it accurate? Any advice or suggestions in this regard?

It's not an Access limit. It may be the limit on the number of
simultaneous connections to a workstation running a non-server operating
system.

 

[Joseph Meehan]

In his book "Access VBA Programming for Dummies", page 299, author
Alan Simpson discusses splitting a database into a front end and a
back end to enable simultaneous use. The front end is then
distributed to each user "up to a maximum of five simultaneous
users". This seems a very low maximum - probably not one that I can
live with. Is it accurate? Any advice or suggestions in this regard?

Well five would be safe, but in real life most users report 20-50
depending on the network and design and the amount of user traffic.

I had maybe 50 possible users, but I doubt if it ever got over 25 and I
never experienced a problem related to multi users. It was usually my
programming errors.

 

[David Portwood]

The author is officially off my Christmas list. If he had written "5" I
could have believed it was a typo. But he wrote "five" and scared me down to
my toes.

I sold my boss on converting from Excel to Access exactly because I know
Access allows simultaneous access to its tables. But we'll have, typically,
five to ten simultaneous users - at least four data entry people plus
various sups browsing/editing at their whim. And that number will probably
increase in the near future.

I had visions of knocking on my boss' door tomorrow morning and telling her
we couldn't use Access after all - after she'd bought 50 licenses.

Giving the Devil his due, however, the rest of the book seems well written
and very clear. Extremely basic information, of course, which is just what I
need right now.

 

[Tony Toews [MVP]]

I had visions of knocking on my boss' door tomorrow morning and telling her
we couldn't use Access after all - after she'd bought 50 licenses.

Umm, well, actually you likely didn't need all fifty licenses. Five or ten licenses
for power users to create their own queries or reports. The rest can use forms and
reports you've created with an Access runtime. You purchase it once (or download
the A2007 version for free when it's available) and you have a license to
redistribute the runtime with your app as much as you want.

Microsoft Access (Office) Developer Edition FAQ
http://www.granite.ab.ca/access/developereditionfaq.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

 

[Tony Toews [MVP]]

In his book "Access VBA Programming for Dummies", page 299, author Alan
Simpson discusses splitting a database into a front end and a back end to
enable simultaneous use. The front end is then distributed to each user "up
to a maximum of five simultaneous users". This seems a very low maximum -
probably not one that I can live with. Is it accurate? Any advice or
suggestions in this regard?

This is *wrong*. I've had 25 users in all day long in one of my apps.

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

 

[dbahooker]

Access MDB is crap

don't try to use it for more than 5 users.. do you really think that
these idiots on this newsgroup know more than an AUTHOR?

come on

 

[dbahooker]

and I have had problems with 5 users and only 25 mb of data

Access MDB is crap, don't use it for anything

fire anyone using MDB and then spit on them

hope that helps- I'm being sincere and brutally honest

-Aaron

 

[Fred Boer]

<Smile> So the poor OP *still* has to go and tell her she bought licenses
they didn't need..

Ah well... She might never know if none of us tell her.... Everybody!
Ssshhhhh......

Fred Boer

 

[Guest]

Hi David,

As others have already indicated, Access can easily handle more than five
simultaneous users. Here is an article that you may find helpful:

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


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Tony Toews [MVP]]

don't try to use it for more than 5 users.. do you really think that
these idiots on this newsgroup know more than an AUTHOR?

Yes. My website is the equivalent of a book.

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

 

[Joseph Meehan]

Access MDB is crap

don't try to use it for more than 5 users.. do you really think that
these idiots on this newsgroup know more than an AUTHOR?

You have proven that some don't.

Does writing a book make you more intelligent?

 

[Larry Linson]

Tony, what "a a r o n" says may well be true for any software he might
create, regardless of the development tools. Haven't we said, "If you work
at getting every factor as far from perfect as possible, you can create an
application that won't support even one user."?

Larry

 

[dbahooker]

tony

what the hell are you talking about

you're a friggin MDB cry baby

shut the **** up before you get hurt, old man

 

[dbahooker]

Tom

you're mother ****ing full of crap and you know it

lose the training wheels; you fat lazy newbies

leave MDB to the retards and cripples-- like michael kaplan


you dipshits should build a time machnie and go back to the 90s---
that is the last time that MDB was relevent for anything.

Access _ROCKS_
but MDB sucks balls

 

[dbahooker]

Larry

what the hell are you talking about MDB _WUSS_

lose the training wheels kids; even M$ admits that MDB has been
obsolete for a decade