473,598 Members | 3,128 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MSACCESS.exe process does not stop when user exits Access (revisited)

I found a post on this problem from 2004, but no one at that time
replied to it- I'm hoping to have better luck than the original author!

As the subject states, I'm running into a problem where the
msaccess.exe process does not end once a user exits a database. The
author referred to a possible connection to conditional formatting, and
I do use that feature a lot.

Any help would be appreciated...t hanks!

Jan 19 '06 #1
4 3707
Keith H. wrote:
I found a post on this problem from 2004, but no one at that time
replied to it- I'm hoping to have better luck than the original author!

As the subject states, I'm running into a problem where the
msaccess.exe process does not end once a user exits a database. The
author referred to a possible connection to conditional formatting, and
I do use that feature a lot.

Any help would be appreciated...t hanks!


My first guess, if i ran across this myself, would be to step through
all the code firing for form unload and form close events to make sure
there's not a form somewhere that has Visible=False, which isn't closing.

As I said, though, it's a guess.
Jan 19 '06 #2
This is not an easy problem to solve.

The first thing to do is establish the absolute minimum steps required to
cause the problem.
Once you've done that you know the bounds of the code to check.
Then concentrating on the code identified above step through checking that
any recordssets you open are closed and set to nothing any database objects
are set to nothing (if you create them using opendatabase then close them as
well), any forms/reports opened are closed and any object variables are set
to nothing (closed if appropriate).

You can then check for testing conditions where you use the default property
instead of specifying it; e.g.
If rs.fields(0) then ' relying on the default property

instead of
If rs.fields(0).Va lue = true then ' specifying the property.

If all this fails then report back and we'll see ifanything else can be
done.
--

Terry Kreft
"Keith H." <hi**********@h ol-mac.com> wrote in message
news:11******** **************@ g44g2000cwa.goo glegroups.com.. .
I found a post on this problem from 2004, but no one at that time
replied to it- I'm hoping to have better luck than the original author!

As the subject states, I'm running into a problem where the
msaccess.exe process does not end once a user exits a database. The
author referred to a possible connection to conditional formatting, and
I do use that feature a lot.

Any help would be appreciated...t hanks!

Jan 20 '06 #3
Thank you both for your replies. I was intimidated at first, since our
company has around 90 or so Access applications, but I believe I have
found the "offending" one. Terry, I am working on the "minimum steps"
portion of your message now- I am trying to recreate the event or
series of events that forces the process to stay running. Once I
recreate the problem, I'll check the underlying code of all open
objects.

Forgive me for my lack of coding experience, but I have a related
question: users here typically exit an application by just closing
Access. From the sound of both your replies, apparently that may not be
sufficient to clean up any open objects, recordsets, etc. Is that
correct?

Jan 20 '06 #4
If the code cleans itself up properly then that's OK.

--

Terry Kreft
"Keith H." <hi**********@h ol-mac.com> wrote in message
news:11******** ************@g1 4g2000cwa.googl egroups.com...
<SNIP>

Forgive me for my lack of coding experience, but I have a related
question: users here typically exit an application by just closing
Access. From the sound of both your replies, apparently that may not be
sufficient to clean up any open objects, recordsets, etc. Is that
correct?

Jan 20 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
2405
by: Harald Armin Massa | last post by:
I need to do some synchronisations like in a cron.job import time from threading import Thread class updater(Thread): def run(self): while True: do_updates() time.sleep(600)
1
2119
by: Mike | last post by:
Using Windows XP SP-1 with all security udpates installed MS Access version 10.2627.3501 SP-1 (all service packs to be installed over the weekend) MDAC 2.8 Jet 4.0 SP 8 When the database and access are closed, the MSACCESS.EXE process is left running and will not allow another instance of Access to be opened until the original process has been terminated.
6
1783
by: David Sullivan | last post by:
Hi I have a problem with a database where certain users are closing access (by clicking on the X in top right-hand corner) instead of using a command button before they fill in all relevant fields. Q. Is there a way of not allowing them to exist access using the this way and use the command button? Thanks in Advance
29
4381
by: keredil | last post by:
Hi, Will the memory allocated by malloc get released when program exits? I guess it will since when the program exits, the OS will free all the memory (global, stack, heap) used by this process. Is it correct?
0
6684
by: Kirk | last post by:
The following C# web service works fine until you uncomment the lines setting UserName and Password. Then, Process.Start throws an Access is Denied Exception. This is with .NET 2.0, of course (1.1 does not support running a process as a different user). I'm running everything on Windows Server 2003. I have impersonation enabled in my web.config, and I'm using Integrated authentication on the IIS virtual directory that this aspx is in....
7
5133
by: dkarin00 | last post by:
I have a form with a number of bound text boxes on it. When the form opens, it retrieves data from a table. I want the user to change data in one or more of the text boxes without any data from the form updating the table until the user presses a "save" button. Simply, I want the user to see in the form the data that they want changed without it impacting the database in any way until a "save" button is pressed. I tried putting...
0
1462
by: Petra | last post by:
Hi! I don't know how to handle the following problem: When a User clicks on the detail view of an item, I lock the item in the database. If the user exits with clicking the cancel or ok button I unlock the item and everything works fine. But if the user exits just closing the explorer window or clicking on an other menu item in the frame, the item is still locked. I tried to load an aspx script which unlocks the item in the unload...
0
1081
by: vamsioracle | last post by:
hi all I just want to know what are user exits. Please provide me the detailed info about user exits in oracle reports thank you in advance
2
1968
by: gsherp | last post by:
How does one execute code when the user closes the browers window by clicking on the top right corner . I need to log out user and do a database write when the user closes the brower. I do these to clean up the database when the user exits before actually logging out. I was told to user pageX, but does not seem to work either. Again, I am having trouble with firefox. Thanks.
0
7985
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
7896
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8389
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8393
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
6713
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
5848
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
3939
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2411
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1503
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.