Results 1 to 3 of 3

Thread: Is MS ACCESS Scalable ?

  1. #1
    Join Date
    Aug 2009
    Posts
    50

    Is MS ACCESS Scalable ?

    Gents,

    How many user MS ACCESS can support simultaneously more than 500 ?

  2. #2
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Quote Originally Posted by FMKA View Post
    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)

  3. #3
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    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
  •