473,326 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Is there some way to shut down Access automatically?

I have a simple database that is used to track experiemnts in a
research lab.
I make it compact and backup each night, but when users leave it open,
that fails.
Is there a way to set the mdb so that if there is no user input for
say 30 minutes, it shuts itself down?

Do I write an on timer procedure that resets a counter when the main
switchboard opens and then resets the timer to 0 each time the
keyboard is used to input information. After 30 minutes of inactivity
it loops to end program?

Thanks
Jerry
Feb 2 '06 #1
3 4628
You will find some information on this here:

http://support.microsoft.com/kb/210297/en-us

One thing the article doesn't mention is how to handle a partially completed
record entry if the user left it that way. I would recommend aborting the
entry, since a partial entry would not be correct data. You would have to
let the users know that you are doing this so that they will know to not
expect what they partially completed to still be there the next day when
they come in. Also, you may want to check the time of day in addition to the
idle time if this is only causing you a problem at night and only shut down
the database if it has been idle and it is after quitting time. If the file
hasn't been idle, then you may have someone working late. In this case,
you'll just have to ask them when they'll be done or ask them to close the
file because you need to do some work.

--
Wayne Morgan
MS Access MVP
<je*********@pioneer.com> wrote in message
news:64********************************@4ax.com...
I have a simple database that is used to track experiemnts in a
research lab.
I make it compact and backup each night, but when users leave it open,
that fails.
Is there a way to set the mdb so that if there is no user input for
say 30 minutes, it shuts itself down?

Do I write an on timer procedure that resets a counter when the main
switchboard opens and then resets the timer to 0 each time the
keyboard is used to input information. After 30 minutes of inactivity
it loops to end program?

Thanks
Jerry

Feb 2 '06 #2
You will find some information on this here:

http://support.microsoft.com/kb/210297/en-us


Great article and suggestion Wayne.
I got it to work fine in a test database

Would you check time and alter execution branching with a Case or an
If syntax? I could see either working fine since its a simple thing
to see if

now() (formatted for time) > 1900 but < 0600, then execute the
shutdown

Jerry
Feb 2 '06 #3
The choice between an If...Then...Else and a Select Case would be which ever
is easier for you to type and easier to read and follow later if you need to
make changes. If you're going to wind up with a bunch of
If...Then...ElseIf...Then, etc, then I'd usually go for the Select Case.

--
Wayne Morgan
MS Access MVP
<je*********@pioneer.com> wrote in message
news:it********************************@4ax.com...
You will find some information on this here:

http://support.microsoft.com/kb/210297/en-us


Great article and suggestion Wayne.
I got it to work fine in a test database

Would you check time and alter execution branching with a Case or an
If syntax? I could see either working fine since its a simple thing
to see if

now() (formatted for time) > 1900 but < 0600, then execute the
shutdown

Jerry

Feb 2 '06 #4

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

Similar topics

193
by: Michael B. | last post by:
I was just thinking about this, specifically wondering if there's any features that the C specification currently lacks, and which may be included in some future standardization. Of course, I...
4
by: Claire | last post by:
Running XP pro, SP2. Visual studio .NET 2003. App written in C# I have written an application that hides itself when run and shows a notification icon in the system tray. If the main form is...
1
by: nikola.bucic | last post by:
Is there any code so that I can call shut down dialog box from my program? Under shut down dialog box I mean the one that is shown when you click on Start -> Shut Down. Thanks in advance.
2
by: vna | last post by:
Hello Everyone, Please send me the code for a system to automatically shutting down the system by specifying the time.Can use either C# or ASP.Net. Please help me asap. Regards, Vna
7
by: mangesh | last post by:
Is there any function in standard library that can forcefully release memory associated with a process(application) ? Regards Mangesh .
4
by: mark4asp | last post by:
How can I shut down (only one) ASP.NET website on the server. Problem. I have updated my web-site but the site which I see is the old one (the one there prior to the update). I do I force...
0
by: ArkJ | last post by:
Hello. I have a little problem. I created a little Service which uses SIP, all works rather well, but when I want to shut it down in the Services panel, it looks as if it's shut down, but in fact...
6
sashi
by: sashi | last post by:
Shut down Windows For various reasons you may require a shut down of Windows to happen programmatically. For instance if the installation of your program requires system reconfiguration. The...
4
by: Saher | last post by:
Hi, im new on this forum and just joined today. I HAVE A HUGE PROBLEM! My microsoft access does not work. I click on the link, that opens up to microsoft access, its fine untill then. But when i try...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.