Jim Dettman
jimdettman at verizon.net
Fri Aug 31 14:40:43 CDT 2012
Brad, The reference count is internal to Access/VBA and is part of the process memory space. I'm sure you could poke through the memory from the OS level, but it's not in any standardized form that the OS would be aware of. Probably not saying that well, but the short answer is no. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Friday, August 31, 2012 03:16 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access Won't Close All, Is there possibly some way to obtain a list of "Open Objects" or "Open Reference Count" from a utility "Outside" of Access? Is there information somewhere deep within Windows that could be obtained? I am coming from an IBM Mainframe background. Our systems programmers had great diagnostic tools to look at information stored inside the operating system. I wonder if there are such tools available in the Windows world that could help with the issue of Open Objects. Thanks, Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Thursday, August 30, 2012 9:00 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access Won't Close How about open objects to make it easier to track down where you forgot close/set to nothing? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Thursday, August 30, 2012 6:21 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access Won't Close <<Best guess, invoking DoCmd creates an object behind the scenes?>> That's interesting and sure sounds like it. Never knew there was a distinction between DoCmd.Quit and Application.Quit (there really shouldn't be either). Which brings to mind a feature which I always wish Access had; a way to inspect the open reference count and list them. That would be really interesting to look at. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Thursday, August 30, 2012 09:05 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access Won't Close Best guess, invoking DoCmd creates an object behind the scenes? DoCmd is a property of the Application object, and if you look at Help it says: "You can use the DoCmd property to access the read-only DoCmd object and its related methods." So when you invoke Docmd.Quit you have created another Application object on the fly. Whereas with Application.Quit you are using the existing Application object. Something like that anyway! Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Wednesday, August 29, 2012 5:52 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access Won't Close Brian and Lambert: So I substituted Application.Quit for DoCmd.Quit and that solved it. Go figure... Thanks Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Tuesday, August 28, 2012 10:03 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access Won't Close Rocky, make sure any object you open is closed and it's variable set to nothing. Access has no idea if it's been called as an automation server or not. When it goes to close, if it sees an open reference, it minimizes to the task bar assuming that another program is not finished with it yet. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Tuesday, August 28, 2012 12:55 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Access Won't Close Dear List: My client wanted an email function in his app. No problem - they use Outlook and I had the code already I could crib from another app. However, now when I exit the app, Access doesn't close - can't close it from the X, have to use the Task Manager. This happens if I just start the app and click exit from the opening splash screen. I'm pretty sure it has to do with Outlook (which is open all the time on my box). And I remember reading about this on the list years ago. Does anybody know the problem/solution? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com <http://www.e-z-mrp.com/> Skype: rocky.smolin -- 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 -- 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 -- 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 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com