Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2009

    Post Unanswered: More Than 10 Users while connection MS Access through ODBC

    I m developing business applications in Delphi 6 for small units (departments) and using BDE.

    Currently I am using MS Access which resides at shared folder. Each user have installed BDE and connect with DB through ODBC connection. But issue is now when more than 10 user trying to connect to DB they get error "No more Connection made to this remote computer..."

    As i have searched that this error is because of Windows XP limitations. Your support and help in this regard will be highly appreciated.

    -> Is there any way to have more than 10 connections (Windows XP SP :: Where DB is available).

    -> What are the alternatives? Can it be resolved if i will use MS SQL Server / MySQL.

    -> Are there any changes are required at application end while using SQL Server or MySQL.
    Last edited by farhanArain; 04-02-09 at 04:05.

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 10
    Moved to Access topic as I feel you will get more targetted response there
    Home | Blog

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    I have the same problem at a site; they have exactly 10 users and if they are all there and logged in, I can't get my laptop to connect to the server until someone else logs off.

    My issue is that XP Pro can only have 10 network users connected, then it starts denying network services.

    This cannot be "bypassed" as far as I know.

    As far as I know, the only remedy is to go to a server -- like Windows Server 2008 -- and purchase enough "seats" or "CALS" or whatever they call them now.

    If this is the same thing that is in effect here, then the answer may be the same - server software that allows > 10 users.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Mar 2009
    Provided Answers: 14
    You won't get more than 10 connections to XP. See:
    Inbound connections limit in Windows XP

    Have a nice day!

  5. #5
    Join Date
    Jun 2004
    Arizona, USA
    Although I'm not a fan of having many users connecting to Access data file simultaneously, this issue isn't with Access - it is with XP. No matter what database you try to use with XP as the 'server,' you'll still have that 10 client connection limit. I suppose you could install a linux box & add postgresql on the linux platform - then you could handle a thousand concurrent connections or so.

    Try having your users connect, load data into a recordset in baqtch update mode, then disconnect the recordset & close the connection.

    When you need to update the data, reconnect, perform the update, then disconnect again. In other words, don't have the clients just sitting there, tying up a connection, when they're not actually using the connection.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

  6. #6
    Join Date
    Mar 2009
    Provided Answers: 14
    If you use linked tables you can just create them on the fly when you need them, then discard them as soon as they are not required any more.
    To create such a table:
                Set tdf = dbs.CreateTableDef()
                tdf.Name = <TableName>    ' Name in this database
                tdf.SourceTableName = <RemoteTableName>    ' Name in the remote database
                tdf.Connect = <ConnectionString>
                dbs.TableDefs.Append tdf
    To delete it:
               DoCmd.DeleteObject acTable, <TableName>
    Have a nice day!

Posting Permissions

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