Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

How to fix Access Database Error Message: 'Some table rows show #Deleted'

Tags: table query

When you try to retrieve, insert, or update records in access database tables then sometimes some Table rows shows "#Deleted" error message.  This error means that the table or its index is get corrupted. To resolve this issue, you have to repair your corrupted index or table. Here are all steps: 

If index get corrupted then try following steps to repair corrupted index: 

1.If the table has any relationship then first delete it: 

In Access 2007 or 2010: Database Tools>>choose Relationships. 
In Access 95 – 2003: Relationships from the Tools menu.

2.Open the table in design view. Open the Indexes box, and delete all indexes. Save. Close. 

In Access 2007 or 2010: Indexes is on the Table Tools ribbon.
In Access 95 – 2003: it is on the View menu.

3.Select the table in the Database window (Access 95 - 2003) or Nav Pane (Access 2007 and later.). After that Copy and Paste & give a new name. 

4.Create a Query into the problem table. Now check that you can see the all records. Change it to an Append query, telling Access to append to the new table. After that Run the query. 

Access 2007 and 2010: Append is on the Query Tools ribbon
Access 95 – 2003: Query menu 

5.After that check that all the data is available in new table, and then delete the old table.

6.Compact the database.

7.Rename the new table so it has the name of the old table.

8.Recreate the indexes and relationships that you have destroy above.

If table get corrupted then try following steps to repair corrupted table: 

1.Create a query into the table.

2.Attempt to exclude the corrupted rows. 

3.Once you have the best range of uncorrupted records you can retrieve, change it to a Make Table query. Make Table is on Query menu in Access 95 - 2003; in Access 2007 or 2010, it is on the Query Tools ribbon under Query Type.

4.Run the query to create the new table.

5.Delete the old table.

6.Compact the database to get rid of any reference to the problem table:

7.Rename the new table to the name of the old one.

8.Recreate the indexes and relationships you destroyed above. If you are unable to create a relationship, use the Unmatched Query Wizard to identify which records are missing.

9.Again, programmatic re-creation may help.

These are the different steps to repair corrupt indexes & tables but you can also try one common method to repair corrupt index & table that is Advanced Access Database Recovery Software. These software repair all corrupt access database objects & files. You can also try these software when all steps get failed to repair your corrupt index & table.  



This post first appeared on All About Database Recovery, please read the originial post: here

Share the post

How to fix Access Database Error Message: 'Some table rows show #Deleted'

×

Subscribe to All About Database Recovery

Get updates delivered right to your inbox!

Thank you for your subscription

×