J
James
is there a way to increase the number of recordsets i can open? im limited
to about 85 right now...
to about 85 right now...
Well, I have no idea why you need to open so many recordsets?
Something seems wrong, very wrong here...
However, I have no problem opening 200 recordsets at the same
time......
im using access 97 if that matters? p.s. im opening so many because i
am using a recursive function to walk thru a hierarchy of employees.
there's probably better ways to implement this but i already have it
working except for one part and it complains here.
Albert D.Kallal:
Thank You! do you know off hand how i can count how many recordsets
my db currently has open?
Joerg Ackermann said:There's no such limit when you open the recordsets
in that way:
Sub opentables()
Dim db As DAO.Database
Dim rstBuf(200) As DAO.Recordset
Dim i As Integer
Set db = DBEngine.OpenDatabase("f:\backend.mdb")