Results 1 to 2 of 2

Thread: "TOO MANY ACTIVE USERS" ERROR

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jan 2000
    Location
    Greenville
    Posts
    73
    I use ADOs and some DAOs throughout my project and I keep getting this awful message saying "TOO MANY ACTIVE USERS" and cannot go any further. Does anyone know what this is about or what I neeed to do?

    I am using this to open my ADOs:

    With Adodc1
    .Mode = adModeReadWrite
    .ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=S:\DBAPPS\Repo\RepoInv.mdb"
    .CommandType = adcommandtext
    .RecordSource = "Select * from LocationTracking Where locationtracking.AccountNum = " & "'" & frmRepoInventory.txtFindAccount.Text & "'"
    .Refresh
    End With

    AND THIS for my DAOs:

    Set db = DBEngine.OpenDatabase("S:\Dbapps\Repo\RepoInv", False, False)
    Set tb22 = db.OpenRecordset("holdcode")

    tb22.Close
    db.Close




  2. #2
    Addicted Member
    Join Date
    Jan 2000
    Location
    Fresno, California, USA
    Posts
    195
    The SQL-Server 7 that came with my MSDN subscription had a 10 user limit. This might be something similar. A less than full version limitation.

Posting Permissions

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



Click Here to Expand Forum to Full Width