Make-Table Query Shuts Down Computer

[TC]

I'm experiencing an unusual problem. When I run a specific make-table
query on a computer, that computer shuts down. The computer shuts down
completely, without warning, as if a power failure occurred.

I can run the query without any trouble on other computers. I can also
run other queries on this computer, including make-table queries which
create much bigger tables.

When it works (on other computers), the make-table query creates a
table of about 80,000 rows. The shut down occurs after about 5
minutes.

I believe this is a hardware problem, so I've recommended to the user
that they work with the IT department to get it fixed. However, I'd
also like to offer a reasonable theory about what is happening. Can
anyone offer any ideas? How can Access cause the computer to shut
down? What mechanism makes it possible?
-TC

[ruralguy via AccessMonster.com]

Flakey RAM can cause such a problem.

TC wrote:

>I'm experiencing an unusual problem. When I run a specific make-table
query on a computer, that computer shuts down. The computer shuts down
completely, without warning, as if a power failure occurred.

I can run the query without any trouble on other computers. I can also
run other queries on this computer, including make-table queries which
create much bigger tables.

When it works (on other computers), the make-table query creates a
table of about 80,000 rows. The shut down occurs after about 5
minutes.

I believe this is a hardware problem, so I've recommended to the user
that they work with the IT department to get it fixed. However, I'd
also like to offer a reasonable theory about what is happening. Can
anyone offer any ideas? How can Access cause the computer to shut
down? What mechanism makes it possible?

-TC

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200706/1