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
 
Disregard - I had a runtime syntax error that was hosing things up... :-)

-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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Recordsets 5
Dim rs as recordset or object? How to check if an rs is open? 39
Is it possible to use multiple recordset objects in a query? 1
Getting Totals with Recordsets 1
Trouble cloning a reports recordset 1
Getting At the Recordset Data 2
A theoretical question: how best to manage perpetual recordset needs? 25
How to tie a record set to a form at run time? 4

Back
Top