delete and update queries hung

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

I have some delete and update queries that when I ran them
I would get a msg "...deleting/updating ##### records..."
then it would sit there for a long time.

I had to close the database with NT task manager and open
it again.
If I look at the tables that I were deleting/updating
using the above mentioned queries the data were
deleted/updated.

Is there a way to fix this problem?

Thank you very much!!!!
 
I have some delete and update queries that when I ran them
I would get a msg "...deleting/updating ##### records..."
then it would sit there for a long time.

I had to close the database with NT task manager and open
it again.
Click to expand...

This is an excellent way to cause irreversible corruption of your
database. DON'T DO IT! unless it's *really* hung (i.e. 30 minutes or
more).
If I look at the tables that I were deleting/updating
using the above mentioned queries the data were
deleted/updated.

Is there a way to fix this problem?
Click to expand...

Doublecheck that your code isn't setting the SysCmd message and
failing to clear it. It sounds like the query is running OK and just
the message is hangning on for some reason.
 
Thanks John!!

Yes it's 30 minutes or more.

These are just queries, no codes, Just individual queries.

Thanks!
 
Back
Top