ADezii  8,834
Recognized Expert Expert
Can someone please tell me the MAXIMUM number of concurrent users that
Access 2003 allows for a Front/Back End architecture? I am placing all data on a departmental server and intend to customize individual Front Ends on what will probably be several hundred Clients. I had heard that the MAXIMUM number of current users is 255 but I must be absolutely sure before I continue developement. (Oracle or SQL Server are not viable options since licensing already exists for Access 2003). Any and all help would be greatly appreciated.
Thanks,
ADezii
7 14894 
Access is great for many things - but what it is not optimised for is supporting a substantial number of concurrent users.
My experience is that 10-15 concurrent users is the maximium that Access using Jet can handle comfortably.
If you are even considering supporting around 255 concurrent users forget using Access Jet engine and consider using MySQL as the back-end retaining Access as the front end.
good luck
PEB 1,418
Recognized Expert Top Contributor
It's true that when the number of users increase, the problems with Access appear!
But it depends of the charge of the different tables on minute!
You can manage this big number of users using different databases loaded on the Server! One user on his front end can use tables from different databases!
ADezii 8,834
Recognized Expert Expert
It's true that when the number of users increase, the problems with Access appear!
But it depends of the charge of the different tables on minute!
You can manage this big number of users using different databases loaded on the Server! One user on his front end can use tables from different databases!
Thanks for your input on this matter - it is greatly appreciated
ADezii
 PEB 1,418
Recognized Expert Top Contributor
You also have to take care about stopping the work with the database for repair and compact!
When you use Access when there is a logged user in case of failure of the database it's impossible to repair the database! In your front end application its good to place an algoritm to close the front end applications of all users in case of failure!
It's the same thing when you want to modify the structure of your database!
If you expect to have large amount of data, it's good to use run SQL statements to the network database placing the results in the local machines! It's similar like a WEB Php or other programming interface passes the SQL to the database and obtain the result! Here the obtained result is better to be on the Local machines for better performance!
When You use action queries it's better to use as fast as possible queries. This diminues the number of concurrent users - the users who pass in the same time a query to the database!
Using the local machines and temporary tables installed there can diminue the charge of the network database and decrease the number of concurrent users!
You have to consider the limitations of Access:
Max number of tables: 2000
Max volume of a database: 2GB
Max number of Forms and so on!
And the interruption of the work of your colleages when you modify athe databse or only to repair it, it's also significant, but you can optimize this inconvenients by VB code!
It' s also important to think doing archiving of the information! For exemple the information of one year can be placed in one database, for the new year you open a new database, using the same front end!
In this cases you can place in the new database the active information from the past year!
IF there is a large amount of data your periods can be smaller then 1 year!
So this will be your application to collect and treat the information operatively! For strategicaly needs you have to use similar database and append the new records there! The information will be treated slowly with hours and not be available on all the network and for many users!
Have a good chance!
Sincerly Vladimir /PEB/
ADezii 8,834
Recognized Expert Expert
Thanks for your many helpful suggestions.
ADezii
PEB 1,418
Recognized Expert Top Contributor
Type "Access specifications" in the Help of Access and you'll obtain all the information about the limitations of Access!
ADezii 8,834
Recognized Expert Expert
Type "Access specifications" in the Help of Access and you'll obtain all the information about the limitations of Access!
Thanks,
Best hint I got so far. The number of Concurrent Users is what I originally
thought - 255. Thanks again.
ADezii
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: John |
last post by:
Hi
Is there a reliable way to place a 'number of concurrent users' limit in
vb.net applications?
Thanks
Regards
|
by: Bill |
last post by:
I need to create a temporary file on the file system. I have over 5000 users
What's the best method to ensure uniqueness
Thank
Bill
|
by: Rod |
last post by:
Today and tomorrow we're demonstrating our ASP.NET application to the
external business customers who will be using it (this is what would best be
called a B2B application). I've set things up so that the users
automatically go against our test server for the database. We'll "go live"
next week Monday.
For some reason, while demonstrating the app, it was causing lots of errors
for users. It became apparent that the issue was one...
|
by: Adnan |
last post by:
Hey Ppl,
I'm developing an Online Auction Site using ASP.net and am
experiencing a problem with Transactions in ADO.Net.
When beginTrasaction() function is invoked from a specific connection,
and insertions are made into a table, no other connection can access
the table, until the transaction is committed. I've set the
Isoloation level to ReadUncommited.
|
by: Goran |
last post by:
How many users can access to SQL server at the same time with web aplication
written in C# 2005? What if my database is 1GB and 1000 people access at 1
second - some simple query. My web hosting acc will be
http://www.webhost4life.com or something simmilar!
| | |
by: krvrk |
last post by:
Hi,
I am creating a report for which i need to query a table for total number of users and Concurrent users logged in.
The table will contain Username(nvarcar,not null),SessionStart time(datetime, not null), SessionEnd time (datetime,null), SessionID(int,not null) and ConnectGUID(uniqueidentifier, not null) etc
can any one help me in finding total and number of concurrent logins per day.
Sample Data
|
by: mktselvan |
last post by:
Hi,
Existing running oracle application 11i (11.5.8)
Database version is 8.1.7.4
There is any command / way to know the number of concurrent users for this application.
select SESSIONS_MAX,
SESSIONS_WARNING,
|
by: BradHodge |
last post by:
Reading a post regarding network security on a linked database, I saw this post by PDog on number of users in a network Environment...
I am about to put a very small database (2200 kb back-end) out on the network. I am expecting 75-100 users in the system at any one time. The database is largely Read-Only (with the exception a few record changes made daily).
I have had it in use by ~20 users continuously for the last 6 months, and have...
|
by: mastanrao |
last post by:
I want to findout how many concurrent users are avilable an application and i want allow 4 concurrent users with same username and password and i want to restrict 5 user.whenever user singout 5 with user to be allowed.Please tell me the solution asap.
advanced Thanks a lot
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
