Hi
Is there any way to walk thru memory to find a variable that holds a
reference to a recordset that has been left open? (I use ADO for my
recordsets.)
The reason I want this info:
I am writing code to compact back end files.
If all recordsets, bound forms, combo boxes, etc are closed, the lock
file for each back end db should be automatically deleted (is this
correct?). If so, I can compact the back end databases from the front
end using the compactdatabase method.
However, I close all my forms, but still one of the lock file lingers
on.
The only reasonable hypothesis, seems to me, is that a recordset has
inadvertently been left open. Is this so? And how to discover the
rogue variable and correct the code that left it open... or do I have
to plod my way thru all my ugly code?
At present I have to do the compact and repair in the startup
procedure of the app, which will add to startup times, so not ideal.
Regards
Andrew Wrigley