Corrupted Records in Table

[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?

 

[Van T. Dinh]

Have you been Compacting and Repairing the MDB files regularly.

See Tony Toews' article on corruptions:

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Robert]

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

 

[Paul Fenton]

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