close ALL recordset objects

[kovan]

its mua again.....

i try to close all my recordsets when i am done with them
but some how one stays in the memory.. and next time i open my project it says a certain record cannot open because its already open..
tried debugging it, nothing
this only happends SOMETIMES

anyone know how i can write a function that will go throu all recordset objects in a project and close them down
when a user loggs off?

thankx

[Gary.Lowe]

kovan

you can use the dbengine object



DBEngine.Idle dbFreeLocks
DBEngine.Idle dbRefreshCache



this release any locks on the database

Hope this is of use