2nd running MsAccess Fast removal

[FuzMic]

Hi there

For some unknown reasons there is another instance of msAccess.03 running which is elusive from the Application tab of the Task Manager. This will be visible in the Processes tab of the same.

What can be the cause of this 2nd instance?

Is there codes i can use to clean all instances on ONE GOo?

 

[GinaWhipp]

Sounds like you are not specifically closing a Recordset somewhere...

 

[The_Doc_Man]

Can you be a LITTLE more descriptive, using more quantitative and less qualitative terms, with regard to "elusive" ?

 

[FuzMic]

Closing recordset is already my constant lookout

Sent from my HTC_PN071 using Tapatalk

 

[GinaWhipp]

But if there is an error your routine may stop prematurely leaving a Recordset open. Have you checked for that?

 

[The_Doc_Man]

When you are exiting the application, there are ways to know that a recordset is still open and you could assure closure in that case.

Dim rsT as DAO.Recordset

...

{when about to exit the app...}

    ON ERROR RESUME NEXT
    FOR EACH rsT in CurrentDB.Recordsets
      rsT.Close
    NEXT rsT

...

The idea is that if you at least close the open recordsets, the act of an Application.Quit will do the rest of the cleanup when all implied memory structures are reclaimed as your process memory gets handed back to the O/S for other processes to share.

If your database is ADO, I think there is a corresponding collection but haven't tried that.

This also makes sense if and only if your problem really IS a hanging recordset. A similar method might work using the collection Workspace.Connections to clean up all open connections, but you need to be more careful with this one since you need to be REALLY sure that you want to kill a particular connection. Be further warned that a connection ALSO has a .Recordsets collection because a connection object also supports the .OpenRecordset method. It probably isn't a good idea to close a connection while it still has open recordsets.

 

[FuzMic]

to my peers

Sent from my HTC_PN071 using Tapatalk