Computer switches off when using VB in Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is bizarre!

I am using MS Access 2000 on a portable.
When I run a certain VB macro, it runs for about 12-15 minutes and then the PC switches itself off. No shut down screens or warning just click. I have tried it 8 times and it is repeatable and consistent.
It has never happened under any other circumstances - just this VB macro.

If I interrupt it before the time is up, it seems to be doing what it is suppose to.
It doesn't make a difference or delay if other programmes are running or if I move the mouse, or press keys during this 12-15 mins.
Nothing notable happens at around this time (it is stepping through a large database).

I am guessing it is something to do with XP power options because:
If I run the portable on batteries, it does not switch off.
If I run the same macro on a Windows 2000 machine, it runs fine.
Switching off without shutting down is not a feature of Access that I am aware of.

However, power saving options are set to "Never" do anything (stop disks, hibernate, switch off, etc.).
Screensaver is disabled.
I have checked for viruses and adware.

I am using Windows XP Prof SP1.

Any suggestions?
Thanks
Roger
 
Does the laptop's BIOS have an option to hibernate after xx minutes?
This could be overriding XP's hibernate option. Just a thought.

--

Star Fleet Admiral Q @ your service
--------------------------------------------------------
Roger Nye said:
This is bizarre!

I am using MS Access 2000 on a portable.
When I run a certain VB macro, it runs for about 12-15 minutes and
Click to expand...
then the PC switches itself off. No shut down screens or warning just
click. I have tried it 8 times and it is repeatable and consistent.
It has never happened under any other circumstances - just this VB macro.

If I interrupt it before the time is up, it seems to be doing what it is suppose to.
It doesn't make a difference or delay if other programmes are
Click to expand...
running or if I move the mouse, or press keys during this 12-15 mins.
Nothing notable happens at around this time (it is stepping through a large database).

I am guessing it is something to do with XP power options because:
If I run the portable on batteries, it does not switch off.
If I run the same macro on a Windows 2000 machine, it runs fine.
Switching off without shutting down is not a feature of Access that I am aware of.

However, power saving options are set to "Never" do anything (stop
Click to expand...
disks, hibernate, switch off, etc.).
 
Thanks for your thought. I just checked, but there are no such settings.
Also it only happens in this particular macro.
No other programme, not even during other long VB macros.
Curiouser and curiouser!
Roger
 
Roger Nye said:
This is bizarre!

I am using MS Access 2000 on a portable.
When I run a certain VB macro, it runs for about 12-15 minutes and then
Click to expand...
the PC switches itself off. No shut down screens or warning just click. I
have tried it 8 times and it is repeatable and consistent.
It has never happened under any other circumstances - just this VB macro.

If I interrupt it before the time is up, it seems to be doing what it is suppose to.
It doesn't make a difference or delay if other programmes are running or
Click to expand...
if I move the mouse, or press keys during this 12-15 mins.
Nothing notable happens at around this time (it is stepping through a large database).

I am guessing it is something to do with XP power options because:
If I run the portable on batteries, it does not switch off.
If I run the same macro on a Windows 2000 machine, it runs fine.
Switching off without shutting down is not a feature of Access that I am aware of.

However, power saving options are set to "Never" do anything (stop disks, hibernate, switch off, etc.).
Screensaver is disabled.
I have checked for viruses and adware.

I am using Windows XP Prof SP1.

Any suggestions?
Thanks
Roger
Click to expand...

Check your BIOS power settings (try disabling it as an experiment), if you
can. BIOS can shut the computer down independent of operating system on some
older computers (a very, very, bad BIOS setting in IMHO).
 
Back
Top