473,471 Members | 1,733 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Deleting a file on exit

40 New Member
Hi Everyone,
I'm a long time lurker of these forums, and they've provided me with many answers through google searches. But now I have a question which I can't seem to get answered.

How can I get Access to delete a file when the user exits the database?

I know I can use the "Kill" Function through the Exit button I have created, but I want to know if there is another way that I can ensure the Kill function runs even if the user does not use my exit button (for example if they use the Access close button towards the top right), or if there is a "dirty exit" through Ctrl-Alt-Del.

My intended setup makes it imperative that a certain file be deleted on exiting the database.

Thanks for any insight.
Dec 3 '07 #1
4 2260
Nathan H
104 New Member
Hi Everyone,
I'm a long time lurker of these forums, and they've provided me with many answers through google searches. But now I have a question which I can't seem to get answered.

How can I get Access to delete a file when the user exits the database?

I know I can use the "Kill" Function through the Exit button I have created, but I want to know if there is another way that I can ensure the Kill function runs even if the user does not use my exit button (for example if they use the Access close button towards the top right), or if there is a "dirty exit" through Ctrl-Alt-Del.

My intended setup makes it imperative that a certain file be deleted on exiting the database.

Thanks for any insight.

This article describes how to disable the close button, which would force your users to use the button you want them to. It may be a direction to go...

http://support.microsoft.com/kb/245746
Dec 3 '07 #2
Nathan H
104 New Member
This article describes how to disable the close button, which would force your users to use the button you want them to. It may be a direction to go...

http://support.microsoft.com/kb/245746

Or you can program you Kill function on the form's "On Close" event property, which would be triggered when the database closes (as the form would naturally have to close first). This would work if the form stays open for the duration of the user's work.
Dec 3 '07 #3
BOMEz
40 New Member
Thanks alot for both response. I was just reading the microsoft support page about how to make the close button go away. But the on close option is a whole lot more straightforward the answer was right in front of my nose all along.

Thanks to both responses.
Dec 3 '07 #4
Nathan H
104 New Member
Thanks alot for both response. I was just reading the microsoft support page about how to make the close button go away. But the on close option is a whole lot more straightforward the answer was right in front of my nose all along.

Thanks to both responses.

Glad I could help. I was stuck on the same problem a couple months ago...
Dec 3 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Dave Theese | last post by:
Hello all, Back in C, the remove() API was the language standard way to remove a file. I have not been able to find a similar facility in the streams classes. Can anyone tell me if such a...
5
by: Olaf Gschweng | last post by:
We're new into DB2 and have some problem with DB2 8.1 (?) on a Linux system. We load some big tables of a DB2 database from files every day. We do a "DELETE FROM table" for each table and then we...
2
by: Mathew Hill | last post by:
I am a beginner to the more technical aspects of Microsoft Access (2000) and was wondering if any one can help. I have 3 buttons on a form which add, delete and search for a record. However, when I...
3
by: Nathan Bloom | last post by:
Hi, I have a data entry form (access 2000) that also allows the user to add, update, and delete records from the form. The Delete action is carried out in an event procedure and has the...
0
by: Lyn | last post by:
This one is driving me crazy. I have a table which stores pictures in an OLE Object column, one per record with a few other text fields (caption, date, etc). This table is maintained with a...
2
by: angus | last post by:
hello everybody, i'm having some problems searching a text file and then deleting the line. since i used fileopen(), i can use the eof() function to loop through the file, searching for the...
46
by: DP | last post by:
hi, i've got a form, with a subform in it. i've got a delete button in the subform. the code i;ve got is; Private Sub cmdDeleteRecord_Click() msg = "Are you sure you want to delete this...
6
by: keeps21 | last post by:
I'm having a bit of trouble creating a page to delete a story from the content table in my database. I have checked my DELETE query directly in phpmyadmin and it is working fine. I am echoing...
2
by: optimum | last post by:
I have develop a new coding using C, with some problem where the search and update functions are working but when I enter a record which is not available it getting me to another record, my delete...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
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,...
0
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...
1
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...
0
tracyyun
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...
0
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...
0
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...
0
muto222
php
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.