473,554 Members | 4,705 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 12341
ha************* **@niiralankulm a.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************ ***@niiralankul ma.fi> wrote in message
news:e6******** *************** ***@posting.goo gle.com... 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.orgZE RO_SPAM> 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.c om...
On Mon, 06 Sep 2004 15:18:58 GMT, "'69 Camaro"
<Fo************ **************@ Spameater.orgZE RO_SPAM> 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.orgZE RO_SPAM> 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
2847
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, Level 16, State 1, Procedure sp_grantdbaccess, Line 160 All user IDs have been assigned. All of the MSSQL procedures eventually call...
2
18096
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 something like: "SELECT * FROM table WHERE name=... LIMIT 4, 10 ORDER BY id" in MySQL
24
1698
by: Jim Hubbard | last post by:
Anybody know?
3
2676
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. select top 1 * from xxx; Whereas all the SQL RDBMS' I've used before used select * from xxx limit 1;
7
5116
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 vendor claims that this behavior is a limit of the DB2 system. We asked the vendor how we might get around this issue since most of our user's...
2
2822
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 by bigkey desc;
4
10763
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 limited server capability, I am also aware you can kludge the number to 40, but assume I do not want to do that). As I understand it XP Pro will...
0
1084
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. The data being export out of the report into MS Excel is around 4100 KB. The RAS and IIS 6 is on Server A, while the SQL Server is on Server B. ...
0
2530
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) SELECT item FROM person_item WHERE person_id = '3000' ORDER BY time DESC OFFSET 0 LIMIT 10; total runtime: 0.224 ms
0
1992
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. The number of key fields can vary and as such a request string format is used to collate all the required fields into one URL parameter. This...
0
7615
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7539
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7819
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8055
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
6170
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5446
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5165
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
2030
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
858
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.