I'm using Windows XP Professional with Access 2003. I have a program that I
need to run after I leave for the day and want my computer to hibernate after
the program has finished running. When Access is running my computer won't
hibernate. How do I get this to happen?

It depends on how fast is your machine and how big is the db file


On 5/21/07 3:15 PM, in article
EA9545F6-B70F-41F0-ADC8-(E-Mail Removed), "jspotspencil"
<(E-Mail Removed)> wrote:

> I'm using Windows XP Professional with Access 2003. I have a program that I
> need to run after I leave for the day and want my computer to hibernate after
> the program has finished running. When Access is running my computer won't
> hibernate. How do I get this to happen?

On Mon, 21 May 2007 12:15:01 -0700, jspotspencil
<(E-Mail Removed)> wrote:

>I'm using Windows XP Professional with Access 2003. I have a program that I
>need to run after I leave for the day and want my computer to hibernate after
>the program has finished running. When Access is running my computer won't
>hibernate. How do I get this to happen?

Do you just leave Access open running the app, or are you launching Access
from the scheduler? I'd suggest the latter. Put a Macro in your database which
runs the program and then does a Quit action; name the macro (say) RunProgram.

Launch Access from Windows Scheduler with

"C:/Program Files/yadayada/msaccess.exe" "D:/somepath/mydb.mdb" /x RunProgram

to launch Access with the macro; follow it by a command to hibernate (not sure
what that is, see the Scheduler help).

John W. Vinson [MVP]

MOVE TO SQL SERVER AND USE THE BUILT IN SCHEDULER-- IT IS CALLED SQL
AGENT

SERIOUSLY-- IT'S FREE FASTER, EASIER AND BETTER

IF YOU WANT TO MOVE DATA FROM ABC TO XYZ ON A SCHEDULED BASIS, IT
TAKES ZERO PROGRAMMING

CHOOSE THE RIGHT TOOL FOR YOUR JOB, KIDS



On May 21, 12:15 pm, jspotspencil
<jspotspen...@discussions.microsoft.com> wrote:
> I'm using Windows XP Professional with Access 2003. I have a program that I
> need to run after I leave for the day and want my computer to hibernate after
> the program has finished running. When Access is running my computer won't
> hibernate. How do I get this to happen?

"Susie DBA [MSFT]" <s u s i e d ba @hotmail.com> wrote:

>MOVE TO SQL SERVER AND USE THE BUILT IN SCHEDULER-- IT IS CALLED SQL
>AGENT
>
>SERIOUSLY-- IT'S FREE FASTER, EASIER AND BETTER
>
>IF YOU WANT TO MOVE DATA FROM ABC TO XYZ ON A SCHEDULED BASIS, IT
>TAKES ZERO PROGRAMMING
>
>CHOOSE THE RIGHT TOOL FOR YOUR JOB, KIDS



Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

How many names does this troll use?

Tony Toews [MVP] wrote:
>>MOVE TO SQL SERVER AND USE THE BUILT IN SCHEDULER-- IT IS CALLED SQL
>>AGENT
>[quoted text clipped - 5 lines]
>>
>>CHOOSE THE RIGHT TOOL FOR YOUR JOB, KIDS
>
>Note that this person is really A a r o n K e m p f and that he is not an employee
>of Microsoft.
>
>Tony

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

Hi.

> How many names does this troll use?

About nine, but with various combinations of E-mail addresses, so he has
quite a few different profiles in Google Groups.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

you guys are truly idiots

maybe if you'd stop spreading mis-information and stop speaking partial
truths0-- then maybe you wouldn't have such a hard time blocking the
truthful posts of an ex-microsoft employee



"'69 Camaro" <(E-Mail Removed)_SPAM> wrote in
message news:(E-Mail Removed)...
> Hi.
>
> > How many names does this troll use?
>
> About nine, but with various combinations of E-mail addresses, so he has
> quite a few different profiles in Google Groups.
>
> HTH.
> Gunny
>
> See http://www.QBuilt.com for all your database needs.
> See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
> Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
> http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
> info.
>
>

On May 22, 3:14 pm, "Susie Johnson" <irsint...@hotmail.com> wrote:
> you guys are truly idiots
>
> maybe if you'd stop spreading mis-information and stop speaking partial
> truths0-- then maybe you wouldn't have such a hard time blocking the
> truthful posts of an ex-microsoft employee

He was never an employee of Microsoft.
He was a contractor *at* Microsoft.

It is, in fact, a big difference.

jay

what the hell are you talking about?

the only people I ever met at Microsoft were a bunch of Excel dorks
I don't think that it's a compliment to work at Microsoft

it just means that you don't know Crystal Reports; and you have no practical
database SKILLZ



I was a contractor at Microsoft FIVE TIMES FOR ALMOST THREE YEARS

eat a dick kid


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On May 22, 3:14 pm, "Susie Johnson" <irsint...@hotmail.com> wrote:
>> you guys are truly idiots
>>
>> maybe if you'd stop spreading mis-information and stop speaking partial
>> truths0-- then maybe you wouldn't have such a hard time blocking the
>> truthful posts of an ex-microsoft employee
>
> He was never an employee of Microsoft.
> He was a contractor *at* Microsoft.
>
> It is, in fact, a big difference.
>