Access 2007 Compact and Repair

[Dan Byers]

We have noticed that when there is a corrupted row (i.e. #DELETED is all
fields) the Primary Keys, Indexes and Relationships are still Present before
running the compact and repair utility. After the utility is run, the Primary
Keys, Indexes and relationships of the affected table/tables disappear. The
row that had the corrupted data is still present but instead of #DELETED it
is now #ERROR. We then have to delete this row and re-define the table/tables
Primary Keys, indexes and relationships. The compact and repair utility
should capture this information before repairing, delete the corrupted
information (it’s useless anyway) and rebuild the Primary Keys, indexes and
relationships. If this is not done, the database is not repaired and left in
an unstable condition.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...87a0&dg=microsoft.public.access.modulesdaovba