Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Listing Open Recordsets

Status
Not open for further replies.
PaulSc

PaulSc

MIS
Aug 21, 2000
148
GB
Hi,
Does any know of a routine/way of listing/querying what recordsets are being used at any particular time??

i.e we do various openrecordset(aaaa) and hopefully use the aaa.close & set aaa=nothing etc to reset them but it appears we may be missing out the odd close, causing problems.
Tracking through all the code is next to impossible (the documenter blew up at 3000+ pages!).

Any help/suggestions appreciated.

Cheers.
 
Status
Not open for further replies.

Similar threads

VicM
  • Locked
  • Question
Want to open backend mdb in exclusive mode; is it possible?
Replies
3
Views
137
Darrylles
Darrylles
Ken
  • Locked
  • Question
Listing wrong number of items sold and paid - need help
Replies
5
Views
115
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Export to Excel fails if target already open
Replies
1
Views
95
TrekBiker
TrekBiker
campagnolo1
  • Locked
  • Question
Multiple Queries in one or Recordsets or...? 2
Replies
12
Views
143
campagnolo1
campagnolo1
primagic
  • Locked
  • Question
"Runtime error 2501-The open report was cancelled"
Replies
1
Views
94
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top