Solution of Acc2000 Termination Bug

Here is a generic solution of Access 2000 Termination Bug (the bug is described in MS Knowledgebase article ID = Q223245 - ACC2000: Error When You Close a Form That Instantiates a Class Module):

Modify the Form_Close event procedure described in pos. 8 of MS Knowledgebase article mentioned above - add the following line before setting fObj to Nothing:

CallDEEPTerminator fObj

The CallDEEPTerminator sub is called from DEEPTerminator.mde, which you can download and unzip from this archive deepterm.zip (52937 bytes). The archive has also TermBugSolution.mdb with the tests.
I didn't publish the source code of the solution now (it's very simple BTW) - I promise to put it here as soon as I get 100 feedback e-mails with the approval that the solution worked in different real-life situations with different code samples and application frameworks... If the solution published here will not solve all the real life situations where Termination Bug comes to light without this solution then I'm sorry in advance for any inconvenience...
Please View/Sigh guest book (see below) to add your feedback or send me your feedback by e-mail - shamil@daisy.spb.ru or shamil503@mail.ru. Please don't send large attachments with your e-mails.

This note was published on March 14, 2001

Addendum to note (published on March 18, 2001)

Here are two zip archives with another solution of MS Acess Termination Bug for both MS Access 97 and MS Access A2K - they use Terminator Form (the solution above use different technique, which is available in A2K only)

deepterm97.zip (36912 bytes)
deepterma2k.zip (47152 bytes) - IMPORTANT NOTE - this solution may *not work*, where the solution above (I mean deepterm.zip - A2K solution) is *expected* to work - I write "expected" because of the fact that I didn't yet have enough feedback to say for sure that it will work in most of the real life programming cases...

Click Here to Search This Site

HOME

Last updated: March 18, 2001