[AccessD] Access Won't Close

Brad Marks BradM at blackforestltd.com
Fri Aug 31 14:15:57 CDT 2012


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.




More information about the AccessD mailing list