Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Texas, USA
    Thanked 1 Time in 1 Post
    Is there a concurrent user limit in an Access application in whcih the tables are access via linked table manager that connects toi a SQL Server (2005) database?

    IN our company one branch has an Access developed app where the DB is on one of my SQL Server (255) instances and till today we've had no complaints form them. Starting today it appears as if only 10 users can get in and we say that because once an 11th user tries to get in the user that logged in last is bumped out.

    There's no user limit on SQL Server for this database and so whatever limits there are they are on the Acess end. It was my understanding that acess could at least in tehory connect to 255 users so I'm at a lost on this one.

    I am familiar with Access in general but I was not involved with the development of teh Access application so I know very little abou it.


  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 58 Times in 58 Posts
    The limit of users connecting to an Access .mdb database is 255, so the users shouldn't be kicked out when an 11th user connects. To really help, we need to know more about the application. What version of Access is being used? Also what format is the front-end app - .mdb or .accdb? Finally, is this a shared front-end? (The recommendation - which I heartily support - is to deploy the Access front-end to the local workstation, or in a terminal services environment, give each user their own copy on the Terminal Services server.)

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 33 Times in 33 Posts
    You said this just started happening today. Did they not have more than 10 users before? I don't see this as an Access problem, unless (as Wendell asked) if a single Access frontend is being shared by all the users. Even then I'm not sure you'd get this kind of response.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts