Greetings,
I have an application which has recently gone from being one big piece
of front-end code to being three, i.e. an mdb A that references an mda
B and an mda C. (For what it's worth, in the interest of complete
disclosure, mda B also references mda C).
This application has always closed in the mvps time-honored method of
calling Application.Qui t on the Unload event of the switchboard.
Problem is, now the db closes (the ldb on the back end disappears), but
Access doesn't shut down, and the ldbs on all three front-end projects
are still there.
Before you answer, please consider that
* DoCmd.Quit doesn't do any better, and none of the arguments change
the outcome
* I've read every thread on this forum containing the words
"applicatio n" and "quit", to no avail--which hopefully means there's an
easy answer!
* The two-three references to "quit" "access" in the MSKB don't apply
* I am explicitly closing every object reference prior to invoking said
quit method
So I guess I'm asking, can anyone tell me how to "close" an mda
reference in such a way that the Application will Quit? Or is there
something else I've missed, and I'm asking the wrong question?
Thanks for your time & consideration. 3 2035
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
What version of Access? There was a reported bug about "unable to close
Access" in which one of the solutions was to ensure that all checks of
Boolean values and CheckBoxes be changed from this:
If BooleanVariable Then ...
or
If CheckBox Then ...
To this:
If BooleanVariable = True Then ...
or
If CheckBox = True Then ...
Also, make sure the DoCmd.Quit is in the .mdb file not in the .mda
files.
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQnAFHIechKq OuFEgEQK5NQCfWz IzpRRF23XRhsQ84 fx8lVGPISYAoIMw
6tLGi+SE9gNutVg TTu2ns8IG
=vqzx
-----END PGP SIGNATURE-----
downwitch wrote: Greetings,
I have an application which has recently gone from being one big piece of front-end code to being three, i.e. an mdb A that references an mda B and an mda C. (For what it's worth, in the interest of complete disclosure, mda B also references mda C).
This application has always closed in the mvps time-honored method of calling Application.Qui t on the Unload event of the switchboard.
Problem is, now the db closes (the ldb on the back end disappears), but Access doesn't shut down, and the ldbs on all three front-end projects are still there.
Before you answer, please consider that * DoCmd.Quit doesn't do any better, and none of the arguments change the outcome * I've read every thread on this forum containing the words "applicatio n" and "quit", to no avail--which hopefully means there's an easy answer! * The two-three references to "quit" "access" in the MSKB don't apply * I am explicitly closing every object reference prior to invoking said quit method
So I guess I'm asking, can anyone tell me how to "close" an mda reference in such a way that the Application will Quit? Or is there something else I've missed, and I'm asking the wrong question?
Thanks for your time & consideration.
It's Access 2000 (in the thread title). And yes, I saw that bug--an
Access 97 bug--but that's not the problem. And no, the quit call is in
the principal mdb.
Thanks for taking a shot, anyway.
I've checked and rechecked all my references, stepped through code, and
managed to make Access drop the ldb on the mdb front-end file, but it's
still holding on to the other two, and therefore not closing.
Very, very frustrating. I'll keep at it though...
Just a follow-up for anyone else who may read this now or forever...
I still haven't found a way to get rid of the locking files on mda
libraries. But by converting them to mde files--annoying
mid-development, but otherwise harmless--Access magically quits. So
it's a solid workaround. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Sibylle Koczian |
last post by:
Still trying to learn PyQt from a book about several Python GUI
toolkits, I seem to learn first what doesn't work. The following small
script seems to work, but after closing the window I get the error
message "Fatal Python error: PyEval_RestoreThread: NULL tstate".
Without the line "self.app = app" the error goes away. So I suppose the
main window can't have a reference to the application class. Right?
Using the global variable qApp...
|
by: Max |
last post by:
I have the following code on a form that launches Microsoft Outlook and creates a new email message for the user:
Outlook.Application oApp = new Outlook.Application();
Outlook.MailItem oMail = (Outlook.MailItem)oApp.CreateItem(Outlook.OlItemType.olMailItem);
oMail.HTMLBody = "SOME HTML TEXT HERE";
oMail.Display(oApp);
oMail.Close(Outlook.OlInspectorClose.olDiscard);
|
by: Peter Kleiweg |
last post by:
I have an application written in Tkinter. There is a menu item
'quit' that calls the function 'quit'. If 'quit' is called, it
first checks if there is unsaved data. If there is, it won't let
the application exit unless you confirm to disregard the
changes.
So far, so good.
I want the program to behave identical if the 'close' button of
the application window is clicked. I tried the code below,
|
by: rdemyan via AccessMonster.com |
last post by:
Sometimes users (including myself) accidentally click on the application
close icon in the application menu bar when they meant to just click on the
'X' for the form. Of course the app closes and this is very annoying.
So, I added a messagebox to my hidden StartAppForm in the Unload event. Now
when the application closes the user is presented with a message so they can
abort closing in case they don't really want to close. This has been...
|
by: Jay |
last post by:
In my C# code, I'm attempting to display a message box then quit the win form application I'm
writing if a certain type of error occurs when the application starts up.
In the main form's constructor - FormMain() - if this error occurs, I display a message box then
call Application.Exit().
The problem is that I also need to have some code in my FormMain_FormClosing event handler, but this
prevents Application.Exit() from quitting the...
| |
by: Doug Glancy |
last post by:
I got the following code from Francesco Balena's site, for disposing of Com
objects:
Sub SetNothing(Of T)(ByRef obj As T)
' Dispose of the object if possible
If obj IsNot Nothing AndAlso TypeOf obj Is IDisposable Then
DirectCast(obj, IDisposable).Dispose()
|
by: NeoPa |
last post by:
In VBA (I expect VB would be similar) controlling another Office Application (Automation) can be done using the following steps :
Ensure the Reference (VBA Window / Tools / References) has been ticked for the application you want to Automate.
Set up an application object variable to use (You can use With...End With if you prefer).
Either :
Use CreateObject(Class) to open a new object for multi-instance programs (For single Instance...
|
by: =?Utf-8?B?VGFvZ2U=?= |
last post by:
Hi All,
When I use applcation.exit() in winForm application, the form closed, but
the process is still going!! ( The debug process is still running if debug in
VS IDE). Environment.Exit(0) works fine. But how to do in such following
scenario: if I need to give 2 option for user,1. Quit 2. Restart. In Quit
option, I use Environment.Exit(0) to confirm the process will be stopped. In
Restart option, I can't use Environment.Exit(0) , because...
|
by: Andy |
last post by:
Just noticed something interesting in the above. If you have your program
file set to "Compact on Close" in access 2007 (which is desirable when you
have a larger program that frequently needs compacting), if you use the
following code on an "Exit Application" type button, the compacting on close
won't fire:
Application.Quit acQuitSaveNone
however, if you use:
|
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...
|
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: 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: 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
|
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...
| |