Re: How to stop a running query? esc, crtl+break do not work

If Esc and Ctrl+Break don't work, it probably means it's a particularly
complex query that's working very hard. If Access is processing things in
the background using its own hidden tables, it won't get back to checking
the keyboard untill if finishes a particular step. Sometimes this step can
take hours (yes, I've written queries that do that). If you don't want to
wait, or it really is stuck, the only alternative is to crash Access. Do a
Compact and Repair when you get back in. Hopefully, you've not lost any
data.

<zwasdl@xxxxxxxxx> wrote in message
news:1158263899.505808.280130@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm using Access 2003

thanks



.

Relevant Pages

  • Re: database bloat/size
    ... Then it seems to stay at that mark for a free days or a week ... until I compact it again. ... to work on a particularly complex query it almost instantly expanded again. ... I've found that any time I work on that query I can expect it to balloon. ...
    (microsoft.public.access.tablesdbdesign)
  • Accidentally Removed "File", "Tools" and "Tables" From The Toolbar
    ... I had a heavy object sitting on the "Esc" key and I ... Nothing would work right so I tried to repair the problem... ... DESPERATE!! ...
    (microsoft.public.office.misc)