Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Only two people can log on to the database

35 views
Skip to first unread message

Nance

unread,
Apr 13, 2013, 7:50:13 AM4/13/13
to
A client complained that only two people can log on to the database simultaneously. Where is that limitation set? I didn't (knowingly!) set it in Access. The database is on the director's computer; others link to that computer.

Phil

unread,
Apr 13, 2013, 10:55:09 AM4/13/13
to
Limit is AFIK 255 concurrent users. I presume the database is split into FE &
BE.

Other limits may be imposed by Windows (Xp the limit was 10, but I don't know
the limit on later versions)

Phil

David Hare-Scott

unread,
Apr 13, 2013, 7:57:32 PM4/13/13
to
This is a very odd case, usually you get only one if the first user happens
to get exclusive access to the database, or many if shared. The theoretical
limitation for Access is 255.

What is the architecture? Where is the back-end, where are the front-ends?
Are all the FEs correctly linked to the BE if you logon with them
individually?

Have you verified that it is always precisely two? Is it two in particular
or will any two users do it? Does it make any difference which machine(s)
they use?

It would help if you could say in detail what happens when the third tries
to get access. Is there an error message? What exactly happens?

David


0 new messages