Table Record problem

[Wendy]

Hi

I deleted a range of records which were out of date on my table 3 records
haven't deleted. 2 show up with the #Error in each field the other show
#deleted. When I try and highlight them in table datasheet view I get an
error message box 'Not a valid bookmark' with an OK and Help button, the
help brings up a blank help screen. Ok keeps returning the same message
box, if I can manage to click on a valid record it will go away.

How can I delete these 3 records, I've already done compact and repair
option on it. Running MS Access 2000 sp3 on Windows 2000 sp4.

Wendy

 

[Allen Browne]

1. Uncheck the Name AutoCorrect boxes under:
Tools | Options | General.

2. Delete any relationships this table is involved in:
Tools | Relationships.

3. On the Tables tab of the Database window, select the table, copy (Ctl+C)
and paste (Ctrl+V.) Answer the dialog:
Structure Only.
This gives you a copy of the table without the 3 bad records.

4. Delete the bad table.

5. Compact the database.

6. Rename the new table to the old name if you wish.

7. Then create any relationships that you deleted at step 2.

 

[Wendy]

Thats worked thanks.

Wendy

1. Uncheck the Name AutoCorrect boxes under:
Tools | Options | General.

2. Delete any relationships this table is involved in:
Tools | Relationships.

3. On the Tables tab of the Database window, select the table, copy (Ctl+C)
and paste (Ctrl+V.) Answer the dialog:
Structure Only.
This gives you a copy of the table without the 3 bad records.

4. Delete the bad table.

5. Compact the database.

6. Rename the new table to the old name if you wish.

7. Then create any relationships that you deleted at step 2.