Make-Table Query Shuts Down Computer

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

.

Relevant Pages

  • Re: Make-Table Query Shuts Down Computer
    ... Flakey RAM can cause such a problem. ... completely, without warning, as if a power failure occurred. ... I can run the query without any trouble on other computers. ...
    (comp.databases.ms-access)
  • 2000 to 2005 query processng difference?
    ... I found an unusual problem between 2000 and 2005 I haven't been able ... The query structure is as follows: ... BETWEEN and errors out due to the fact that it is evaluating the ... changing the result of the DATEDIFF function to varchar ...
    (comp.databases.ms-sqlserver)
  • Re: How do I suppress warnings when using an Access MDB as a runtime?
    ... The destination computer can have the macro security settings set to Low to ... avoid the three warning messages. ... > warnings you get when you run an update or delete query. ...
    (microsoft.public.access.security)
  • Re: Import data
    ... To turn off the warning message: how do you do the import? ... > I am transfering Txt file into an Access table. ... >>If the filename on the disk is always the same and the ... >>import), then use a DFirst on it for the Delete query, ...
    (microsoft.public.access.macros)
  • Re: Table/Form/Query Question
    ... warning already, and who is eligible to receive one, then that's much more ... what your data structure looks like. ... the info will be updated via both the query and now ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.queries)