-
Is MS ACCESS Scalable ?
Gents,
How many user MS ACCESS can support simultaneously more than 500 ?
-
Originally Posted by FMKA
Gents,
How many user MS ACCESS can support simultaneously more than 500 ?
If you have your database properly configured for multiple users (split into front end and back end) then you can:
1) Using a JET/ACE back end (Access database) you can have in theory 255 concurrent connections. Practically, you hit a wall at less than 50.
If you need over 255 users then:
2) an SQL Server. This is dependent on the limits of this database server.
I find the number of user is more dependent on the back end database format. Using an SQL server will probably be the best if over 50 users.
With that many users, what will be the size of the back end (how much data)? Some databases, Like Access, have a 2 GIG file size limit.
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC]
Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
-
The Upsizing Tools are Pretty Good ...
... too, if you already have a design in MS Access that you want to scale to MSSQL Server. I've used them recently to get a simple design to 2k8, and everyting went very smoothly.
Just a point of interest ...
Bill
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|