473,287 Members | 2,682 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Limit of users in Ms-Access?

Hi.

In the ldb file you can see the users of the mdb-file. If you open the
mdb-file your machine and username will be written in the lbd- file.
Allthough you close the mdb-file your name won't disappear from the
ldb-file, before every user has closed the mdb-file.
I have heard that there will be problems if the amount of users will
be over 10 in mdb-files. Is that true?

Hannu
Nov 13 '05 #1
6 12308
ha***************@niiralankulma.fi (Hannu) wrote:
I have heard that there will be problems if the amount of users will
be over 10 in mdb-files. Is that true?


I presume you mean in the ldb file. I'm not aware of any problems provided
that the app is split and each user has their own front end.

Regards,
Keith.
Nov 13 '05 #2
Hi, Hannu.

The maximum number of concurrent users for Microsoft Access is 255. The
only limit I've heard of so far about "no more than ten users" is not an
Access limit, but a Windows XP networking limit. If a multiuser Access
database application is placed on a Windows XP peer-to-peer network, then no
more than 10 users will be able to open the file at the same time. Of
course that limit applies to any file on that network, not just the Access
database. The solution to this, of course, is to use a client/server
network with a dedicated server.

If a multiuser database is designed correctly with a split front end and
back end, all users are given Windows "Full control" security permissions on
the network shared directory, and all users are only reading the records,
instead of inserting, updating and deleting records, then the limit of 255
concurrent users _could_ be reached. However, real life doesn't give us
such an ideal scenario.

The number of concurrent users will be limited to the amount of network
traffic and the amount of record lock contention. The record lock
contention can be controlled to some degree by the efficiency of the
database design and database application design. This is where experienced
Access database developers are worth their weight in gold, because they can
often create a fairly robust database system with Access, instead of
creating a much more expensive database system with SQL Server, Oracle, or
another RDBMS.

So, the limit on users depends upon the needs of the database application,
the amount of record lock contention, the network and how it handles
traffic, and the expertise of the database developer. This limit could be
from one user to 30 or more concurrent users in a reliable Access database
system, depending upon all of these factors.
In the ldb file you can see the users of the mdb-file. If you open the
mdb-file your machine and username will be written in the lbd- file.
Allthough you close the mdb-file your name won't disappear from the
ldb-file, before every user has closed the mdb-file.
Since the *.LDB file is not a list of "active" users, don't worry about
non-current usernames and computer names being listed in the *.LDB file.
These entries are never deleted. When another user opens a currently open
database after other users have exited, the new user's username and computer
name will overwrite one of the old entries.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"Hannu" <ha***************@niiralankulma.fi> wrote in message
news:e6**************************@posting.google.c om... Hi.

In the ldb file you can see the users of the mdb-file. If you open the
mdb-file your machine and username will be written in the lbd- file.
Allthough you close the mdb-file your name won't disappear from the
ldb-file, before every user has closed the mdb-file.
I have heard that there will be problems if the amount of users will
be over 10 in mdb-files. Is that true?

Hannu

Nov 13 '05 #3
On Mon, 06 Sep 2004 15:18:58 GMT, "'69 Camaro"
<Fo**************************@Spameater.orgZERO_SP AM> wrote:

This limitation does not exist for the Server versions of operating
systems. You can have a Windows 2000 Server machine hosting the
back-end file, and theoretically have 255 users open it concurrently.

-Tom.

Hi, Hannu.

The maximum number of concurrent users for Microsoft Access is 255. The
only limit I've heard of so far about "no more than ten users" is not an
Access limit, but a Windows XP networking limit. If a multiuser Access
database application is placed on a Windows XP peer-to-peer network, then no
more than 10 users will be able to open the file at the same time. Of
course that limit applies to any file on that network, not just the Access
database. The solution to this, of course, is to use a client/server
network with a dedicated server.

<clip>

Nov 13 '05 #4
Hi, Tom.

That's what I wrote, but you wrote the same thing more succinctly! Perhaps
I should have just written, "Avoid the peer-to-peer network limitation by
using a client/server network with a dedicated server," without the rest of
my verbose explanation.

Gunny
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:eq********************************@4ax.com...
On Mon, 06 Sep 2004 15:18:58 GMT, "'69 Camaro"
<Fo**************************@Spameater.orgZERO_SP AM> wrote:

This limitation does not exist for the Server versions of operating
systems. You can have a Windows 2000 Server machine hosting the
back-end file, and theoretically have 255 users open it concurrently.

-Tom.

Hi, Hannu.

The maximum number of concurrent users for Microsoft Access is 255. The
only limit I've heard of so far about "no more than ten users" is not an
Access limit, but a Windows XP networking limit. If a multiuser Access
database application is placed on a Windows XP peer-to-peer network, then nomore than 10 users will be able to open the file at the same time. Of
course that limit applies to any file on that network, not just the Accessdatabase. The solution to this, of course, is to use a client/server
network with a dedicated server.

<clip>

Nov 13 '05 #5
Tom van Stiphout wrote:
On Mon, 06 Sep 2004 15:18:58 GMT, "'69 Camaro"
<Fo**************************@Spameater.orgZERO_SP AM> wrote:

This limitation does not exist for the Server versions of operating
systems. You can have a Windows 2000 Server machine hosting the
back-end file, and theoretically have 255 users open it concurrently.


That takes care of physical limits but then practical limits will set
in, depending on the design of the application and what's done with it,
you might find performance and/or locking problems at 10 users, or it
may be OK at 50 users, etc. It's one of those "suck it and see" scenarios.

--

\\\\\\
\\ \\ Windows is searching
\ \ For your sig.
\ \ Please Wait.
\__\

Nov 13 '05 #6
The number of users is restricted to 10 if you are running windows
2000 and the database is residing on a local machine on a shared
folder. Microsoft has set the limit to 10 to encourage small
businesses who don't have servers, to buy Small Business Server (or
some product with a similar name).

I have had to battle with this limitation recently and it can be a big
problem. This was resolved in the end by the users to share usage of
the database by closing it when they weren't physically performing any
actions with it.

:)
Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Tom Ostberg | last post by:
There appears to be a limit of ~16378 user Id's possible per database. When adding users we eventually get the message: > exec sp_adduser 'testUser', 'testUser', 'user_group' Server: Msg 15065,...
2
by: Urban | last post by:
hi, I have a question. Maybe You know the equivalent to command LIMIT from MySQL I couldn`t find something like this in MS SQL PS I try to display 10 records begining form e.g. 4 sort by id...
24
by: Jim Hubbard | last post by:
Anybody know?
3
by: Roderick A. Anderson | last post by:
I'm dealing with a project that requires me to query a MS SQL Server. Not a PostgreSQL issue I know but I want to ask if the LIMIT modifier is SQL standard? MS SQL Server uses a TOP modifier. ...
7
by: johnm | last post by:
We have a new CRM application that uses a DB2 7.2 database. Our users noted that the CRM application would not allow them to attach and store any documents over 2 meg in size. When asked, the...
2
by: elein | last post by:
Yes, I vacuumed. Reproduced on both 7.3.2 and 7.5. Brain dead java beans want order by clauses in views that they use. my view is: select .... from bigtable b left join lookuptable l order...
4
by: Bill | last post by:
Hi, I would be grateful if someone could clarify my rather confused ideas of the 10 connection limit on XP/2000 when its being used as a server. (I realise that XP is really a client op sys with...
0
by: Mark | last post by:
Thanks in Advance. I encountered the 4 MB limit recently while using the export feature of Crystal Reports version 9 Report Application Server which uses a MS SQL Server 2000 as a data source. ...
0
by: GeniusTse | last post by:
Hi all, I found a big performance difference between two query with different "Limit" and I think it is not make sense Table: person_item PKey: (person_id, time) Index: (time) Query1)...
0
by: mokoujan | last post by:
Hello all I am currently developing a WCF REST service. One of the requirements is to allow the users to search data via the rest interface. As such key field information is passed in the URL....
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.