Table Corruption When Running Multiple Queries (1 Viewer)

RogerCooper

Registered User.
Local time
Today, 14:19
Joined
Jul 30, 2014
Messages
277
I have a table called Exception Reports which contains the names of various queries which are run twice daily as well as information about the query (who receives the e-mail, the date/time is was last run, the number of records returned, the first record etc.). After the query is run (and any e-mails or printouts needed are executed) the table is updated with information about the query. I have been doing this for many years without much trouble.

Recently, I have the database being corrupted frequently during normal runs. I put the Exception Reports table in its own database, but the errors continue (Putting it in its own database makes repairs much faster, however).

Does anyone have any ideas about how to reduce this problem. Would waiting after each record updates help?
 

Ranman256

Well-known member
Local time
Today, 17:19
Joined
Apr 9, 2015
Messages
4,339
Is it happening from the same PC?
I had 1 pc do this over and over , but when I used another PC, it never did it.
 

Users who are viewing this thread

Top Bottom