Jim Dettman
jimdettman at earthlink.net
Tue Oct 21 11:30:31 CDT 2003
Charlotte/Virginia, FYI I was just involved in another situation where Access hung at close. A DoCmd.Restore (I believe JC ran into this as well some time back for the same reason) that involves a form with a subform. With that one line of code commented out, Access would exit fine. This should be appearing in the MSKB in the not too distant future as Microsoft became involved and has the bug documented. Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Tuesday, October 21, 2003 11:32 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Access Stays Open Access 2000 and XP are much less forgiving of undestroyed objects than 97. Another difference is that a hidden form will keep the database open when you try to quit, which is not the same behavior as 97. Make sure you explicitly destroy any object variables populated using the Set keyword. Also make sure that you use a full evaluation of things like checkboxes in your code. In other words, use If Me.Checkbox = True Then And not If Me.Checkbox Then Or else wrap the expression Me.Checkbox in parens to force an evaluation. Otherwise, Access can hang up on that issue as well. Charlotte Foust -----Original Message----- From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com] Sent: Tuesday, October 21, 2003 4:01 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Access Stays Open I just converted my databases to A2K. When I close the database, Access remains open. Why is it doing this now? I seems to mostly happen when I make some changes to the database. Virginia _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com