A few months ago, a working Access97 system started exhibiting this behavior. About half the time when the .mde is closed, the app window remains open and can then only be closed by using "End task" from Task Manager, or sometimes a right click "Close" will work on the button on the Task Bar (but only on W2K stations, as opposed to NT stations, I think).
Ideas?
--
Message posted via http://www.accessmonster.com 4  1424 
James Birkholz via AccessMonster.c om wrote: A few months ago, a working Access97 system started exhibiting this behavior. About half the time when the .mde is closed, the app window remains open and can then only be closed by using "End task" from Task Manager, or sometimes a right click "Close" will work on the button on the Task Bar (but only on W2K stations, as opposed to NT stations, I think).
Ideas?
Did you modify the code or make any changes in the MDE?
Yes,it's under constant developement, with the users running fresh copies as .mde's. However, I have no idea what had been changed at the point this started, it took a week or so for it come to my attention, and even longer for it become an issue. I had hoped that like similar weird things that often happen with Access, it would eventually go away. So I was just hoping that it wasn't so rare that someone else might have already been down this road and have some ideas where to start looking. It's still just an annoyance, so I can't justify spending days trying to track down the source.
--
Message posted via http://www.accessmonster.com
James Birkholz via AccessMonster.c om wrote: Yes,it's under constant developement, with the users running fresh copies as .mde's. However, I have no idea what had been changed at the point this started, it took a week or so for it come to my attention, and even longer for it become an issue. I had hoped that like similar weird things that often happen with Access, it would eventually go away. So I was just hoping that it wasn't so rare that someone else might have already been down this road and have some ideas where to start looking. It's still just an annoyance, so I can't justify spending days trying to track down the source.
I had this happen occasionally in A97. The best thing I could advise is
making sure all the DAO objects you open you close and set to nothing:
'close recordset and set to nothing
rst.close
set rst = nothing
'same for any queries
qdf1.close
set qdf1 = nothing
'database
dbs.close
set dbs = nothing
The best way to do this, of course is to make sure your procs ALL have
one and only one exit point. Don't have any if statements like:
IF <blah blah> then exit sub/function
Rather have a labelled exit point:
Exit_Proc:
rst.close
set rst = nothing
qdf1.close
set qdf1 = nothing
dbs.close
set dbs = nothing
Exit sub/function
And your if statement can be:
IF <blah blah> then goto exit_proc
Similarly, your error handling section should also have goto Exit_proc
I found when I was disciplined with this sort of approach, the problem
you descibe went away.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Vince |
last post by:
I'm getting this message when I try and run a .net web app
in the development system:
CS0016: Could not write to output file 'c#:\windows
nt\Microsoft..net framework\v1.1.4322\Temporary ASP.NET
Files\ssrpttest\44d149b5\fdee4a07\c22wlbzl.dll' -- 'Access
is denied. '
I just upgraded to visual studio .net 2003 and now none of
my applications wil work!
|
by: MacDermott |
last post by:
I have an Access MDB which instantiates a class in a custom DLL, manipulates
it for a while, then sets it equal nothing.
The MDB does other things,too, and generally behaves itself as desired.
But, if I have done the DLL thing, even though I close the MDB, Access
refuses to close.
If I haven't used the DLL, all is well.
The DLL is one I wrote myself in VB.
I'm quite stumped, and rather guess the problem may be in the DLL (I've also
|
by: Alpha |
last post by:
I have a Window based application that shows up still running in the task
manager when I close it. It reaches the "this.close" statement and then it
stops at the "}" at the section of the following code after the
"Application.Run(new VMSMain());":
static void Main()
{
Application.Run(new VMSMain());
}
|
by: Tom wilson |
last post by:
Yes, I'm absolutely serious.
I'm in the VS.Net editor with an HTML page loaded. All the links are
broken. So I right click an image and choose Properties. The window
appears.
No matter what I do, the properties window won't close. I've tried
Ok, Cancel, the "X" button... the properties window won't go away.
Now for the most ridiculous question I've ever asked,
|
by: Chad |
last post by:
I rebuilt my pc (format and reinstall) running XP and Visual Studio
2003.
My problem is that the IDE won't stop the run session when I close the
web application.
Now when I create a new ASP.net application or open an existing
application, start the application (F5) in the IDE, close the IE window
that the application started up, now you would expect the IDE to also
stop it's debug session ie; run mode. However mine is not, the IDE is
| | |
by: John Ortt |
last post by:
Hi everyone.
I have a database which I have developed in Access 2000 which is working
nicely.
The problem is that my customer only has Access 97. I tried to convert the
database but the main menu won't work.
I has two parts, a mainmenu and a submenu which displays the option buttons.
|
by: Scott F. Brown |
last post by:
Greetings all...
I was playing around with compressing streams and came across a behavior
that I do not understand. I create a stream (input) from the contents of a
textbox. That stream is compressed into another stream (output). I then
copy the stream (output) to another stream (input2). The compressed stream
(input2) is then decompressed into a final stream (output2).
My question is this. I create input2 from output.GetBuffer()...
|
by: alexia.bee |
last post by:
Hi all,
In some weird reason, excel instance won;t die if i remove the comment
from 4 lines of setting values into struct.
here is a snipcode
public System.Collections.Generic.List<frmMain.sDBTest>
LoadTestSet(string TestSetFile,
System.Collections.Generic.List<frmMain.sDBTestDBviewList)
|
by: Josetta |
last post by:
Access 2003
I've been experiencing some problems with my "monster" database the
last couple of days. I imported all objects into a new database
yesterday, which pretty much stopped the crashing problems, but here's
something weird: Whenever I copy an object (reports so far), I am
able to open it and make changes, but when I try to save it (without
closing), it appears to save (message box goes off), but it doesn't.
Then, if I try to...
|
by: Sparky74 |
last post by:
Hi. Can somebody please help me - I cannot get my TCP client application to close its socket one I attempt a send.
It will close the socket fine if I don't call Send or BeginSend. Soon as I do, it won't close.
Thank you
using System;
using System.Collections.Generic;
|
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,...
| | |
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...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
