Corrupted Records in Table

  • Thread starter Thread starter Paul Fenton
  • Start date Start date
P

Paul Fenton

We have a Clients table with some 15,000 records over the past 8 years
and have determined that 2 of these records are somehow corrupted.

What happens is when we run a sales report for dates which include
either of these records, Access wil go forever trying to format the
report. We have to CTRL-Break out of it. If I delete those 2
records, the report runs fine, so I thought well, I'll just delete
them and recreate them with identical information, but when I did
that, I got the same result.

The Clients table is linked one-to-many to 2 other tables,
tblClientImprovements and tblAppointments, cascade deletes.

Does anyone have any idea why this might be happening?
 
Have you tried entering different information to see if it still gets stuck
in a loop? For example, try copying the two previous records. It's
possible that the application isn't handling the data values correctly (for
example, if the report has code in the "on format" event.

Robert Smith
Kaizen Software Solutions
http://www.kzsoftware.com/services/msaccess
 
Robert & Van, thank you for responding. I found that if I deleted the
records, compacted and repaired, THEN reentered them with all the
original information, the problem went away.


Paul Fenton
 
Back
Top