Multiple Recordsets

A

Amanda Payton

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
 
A

Amanda Payton

Disregard - I had a runtime syntax error that was hosing things up... :)

-Amanda
 
M

Marshall Barton

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?
 
Top