473,326 Members | 2,124 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,326 software developers and data experts.

How many users can access a database simultaneously?

Hi everybody,

I am creating an application with MS Access 2003, using a workgroup
file to manage user connections. I already created several groups in
the workgroup file and assigned them to the users to define their
access-level and rights.
Does anybody know how many simultaneous user access can MS Access 2003
handle?

Thanks,

Gabo

Jan 5 '07 #1
8 6919
ga***********@libero.it wrote:
Hi everybody,

I am creating an application with MS Access 2003, using a workgroup
file to manage user connections. I already created several groups in
the workgroup file and assigned them to the users to define their
access-level and rights.
Does anybody know how many simultaneous user access can MS Access 2003
handle?
The technical limit (totally unrealistic) is 255. A well designed app (with
respect to networking and multi-user issues) can go into the low one hundred-ish
range, but that is more likely if most are reading rather than writing and when
all other factors (the network and hardware) are ideal. A poorly designed app
will fall over on two users.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jan 5 '07 #2
ga***********@libero.it wrote in news:1167991825.366187.158000
@q40g2000cwq.googlegroups.com:
Does anybody know how many simultaneous user access can MS Access 2003
handle?
Maybe God? ...

--
lyle fairfield
Jan 5 '07 #3
>Does anybody know how many simultaneous user access can MS Access 2003
handle?

Maybe God? ...
Do you have his email address?

;o)
Jan 5 '07 #4
A lot depends on how regular your network is. If there is a variation in
network latency, your capabilities are much reduces. Also, long memo fields
are particularly treacherous in a multi-user environment.

<ga***********@libero.itwrote in message
news:11**********************@q40g2000cwq.googlegr oups.com...
Hi everybody,

I am creating an application with MS Access 2003, using a workgroup
file to manage user connections. I already created several groups in
the workgroup file and assigned them to the users to define their
access-level and rights.
Does anybody know how many simultaneous user access can MS Access 2003
handle?

Thanks,

Gabo

Jan 5 '07 #5
Gary Floam wrote:
A lot depends on how regular your network is. If there is a variation in
network latency, your capabilities are much reduces. Also, long memo fields
are particularly treacherous in a multi-user environment.

<ga***********@libero.itwrote in message
news:11**********************@q40g2000cwq.googlegr oups.com...
>Hi everybody,

I am creating an application with MS Access 2003, using a workgroup
file to manage user connections. I already created several groups in
the workgroup file and assigned them to the users to define their
access-level and rights.
Does anybody know how many simultaneous user access can MS Access 2003
handle?

Thanks,

Gabo

Why not tell us how many simultaneous users you need and whether they
will be reading only or updating data and you will get a better answer.

Bob
Jan 5 '07 #6
ga***********@libero.it wrote:
Hi everybody,

I am creating an application with MS Access 2003, using a workgroup
file to manage user connections. I already created several groups in
the workgroup file and assigned them to the users to define their
access-level and rights.
Does anybody know how many simultaneous user access can MS Access 2003
handle?

Thanks,

Gabo
My improbability drive CPU
spit out an answer of 42.
I'm not sure of this answer for I
am sure that Doug Adams cannot verify.

James A. Fortune
CD********@FortuneJames.com

Jan 5 '07 #7
My improbability drive CPU
spit out an answer of 42.
I'm not sure of this answer for I
am sure that Doug Adams cannot verify.

James A. Fortune
CD********@FortuneJames.com
What about Ford Prefect? is he available?

Jan 5 '07 #8
Bri

pi********@hotmail.com wrote:
>>My improbability drive CPU
spit out an answer of 42.
I'm not sure of this answer for I
am sure that Doug Adams cannot verify.

James A. Fortune
CD********@FortuneJames.com


What about Ford Prefect? is he available?
Wasn't Slartibartfast the PM on that project? :D

--
Bri

Jan 11 '07 #9

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

Similar topics

7
by: RCS | last post by:
Okay, a rather 'interesting' situation has arisen at a place I work: I need to convert a database from Access to something that can be used over the web. I am currently maintaining and...
1
by: Ren | last post by:
I have set up an access database with a switchboard to multiple forms, reports, etc. I have gotten comflicting information about whether or not staff throughout my facility will be able to view...
1
by: Leon | last post by:
Hi, I am trying to find out what are the big differences between access database Jet engine and SQL Server? If I have serveral web applications (same content different copies) running as different...
5
by: premmehrotra | last post by:
I currently have a multi-user access database which is put on a shared drive L: on a Windows Servers. Entire database is one file premdb.mdb. Users access this database from their laptops....
2
by: James | last post by:
Dear Access Guru's, Hopefully you can help me (as Microsoft don't seem to be able to) We have an Access database on a Windows 2003 server with 5 CALS in our office. Access is loaded onto...
1
by: taleran58 | last post by:
Hi all. I'm writting a multithreading program that will update a loacal Access database. I'm using OleDB connection to get access to the database from each thread and my question is: how do I...
7
by: Allison | last post by:
Hi -- we are a small manufacturing looking for a multi-user database to take customer orders (nothing too complicated, with 3 users total). We think we should be using Access, but are wondering...
3
by: Alex | last post by:
Hello, I am running an Access 2003 database, quite modest in size, that is used by upwards of 5 users. I need to modify the database such that these users can work simultaneously and, in some...
21
by: nihad.nasim | last post by:
Hi there, I have a database in Access that I need on the web. The web page should connect to the database and write records for certain tables and view records for others. I want to know a...
2
by: Scottyp | last post by:
How can I allow multiply user to connect to an access database simultaneously
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.