Results 1 to 2 of 2

Thread: Using Access To Drive A Dynamic Page

  1. 02-10-2003, 03:50 PM #1
    TSweatt
    TSweatt is offline Registered User
    Join Date
    Feb 2003
    Posts
    1

    Using Access To Drive A Dynamic Page

    Hello all,

    I run a couple websites for student organizations on campus, and have a couple dynamic sites that have been driven by MS SQL Server 2000. I've learned that the SQL Server is going the way of the dodo, and students will not be given any access to its replacement. I have imported all my databases into access, and have a valid connection string, however, I am unable to get more than one user connected at one time. Is there anyway around this limitation in MS Access, or is there a better alternative out there? Any input would be appriciated.

    Thanks
    -Tom
    Reply With Quote Reply With Quote
  2. 02-15-2003, 03:15 AM #2
    PinkPanther2003
    PinkPanther2003 is offline Registered User
    Join Date
    Feb 2003
    Posts
    102

    >1 Concurrent User

    There is no limitation for only one user. JET can support up to 255 concurrent users (but no on will ever get there).

    The most I've had is 20. I've heard of 100+ (but conditions would want to be optimal).

    Are you sure that the db isn't opened in exclusive mode?

    What's your connection string look like?

    HTH,

    Peter
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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