multiuser application in vb6.0 with ms access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mohanty2050
    New Member
    • Apr 2010
    • 7

    multiuser application in vb6.0 with ms access

    Hi,
    How can I create a multiuser application in vb6.0 with ms access? In my application I use ADO connection and want to connect around 100 users at a time. Please provide me some samples.
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    You need to store the database file in some shared location to which all the users have read write access.

    Comment

    • vb5prgrmr
      Recognized Expert Contributor
      • Oct 2009
      • 305

      #3
      Access will not allow you to connect more than 20 at a time. See M$ for more information on number of concurrent users allowed. With that many people, I would suggest you immediately upgrade to MS SQL Server and do not pass go until you do! You should be able to download the free 2k5 or 2k8 express versions.


      Good Luck

      Comment

      Working...