Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ODBC - Access (Access 2003)

    We are using an ODBC connection and ASP script to upload data from a flat file to tables in Access. This is a connection made accross the network most offten via a VPN connection.

    We are having issues when the user trys to send more than four files at the same time.

    My questions is this...
    Does Access have a "connection" limit that would allow the first four of these file to upload, but cause the fifth and greater to fail?

    We have been told by our vendor that this is the case. Their product creates the flat file and they wrote the ASP script that transfers the data.
    Our IT folks created the ODBC based on information received form the vendor..


    I have not heard of a limit in Access that would cause this. I have had databases that have more than four concurrent user with no issues.


    Thanks in advance for any help.
    Richard

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ODBC - Access (Access 2003)

    Access has a maximum of 255 simultaneous users (although it wouldn't work very well). However, the user's browser probably has a limit of simultaneously active downloads/uploads. I can't help you with that, there's some info in How to configure Internet Explorer to have more than two download sessions.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ODBC - Access (Access 2003)

    Thanks Hans
    Richard

Posting Permissions

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