Multiple Recordsets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have more than one recordset open at once? I haven't found
anything that specifically states that only one recordset may be open at a
time, but every time I try and open more than one - Access gets "cranky" with
me. ('97 ed)

-Amanda
 
Amanda said:
Is it possible to have more than one recordset open at once? I haven't found
anything that specifically states that only one recordset may be open at a
time, but every time I try and open more than one - Access gets "cranky" with
me. ('97 ed)
Click to expand...


You can have many recordsets open at a time. One issue is
to make sure you close them and set their object variable to
Nothing as soon as you're done with each one.

What are you tring to do and what sort of problems are you
having?
 
Back
Top