not a valid bookmark

[NAS]

When I try deleting all the records form a table, every row deletes except
one. They all say #Error and a warning message appears saying "not a valid
bookmark". The warning message comes up about 5 times each time and appears
whenever I open the table, or click on anything in the table itself. I am
using Access 2003 on Windows XP.

 

[Allen Browne]

The symptoms indicate that you have a corruption in this table.

Given that you want to destroy all the data anyway, try selecting the table
in the Database Window. Then Copy (Ctrl+C), and Paste (Ctrl+V.) Respond to
the dialog that you want Structure Only, and supply a new name for the
table.

You can then delete the original table, and rename the new one.

 

[NAS]

That worked great. Thank you.

The symptoms indicate that you have a corruption in this table.

Given that you want to destroy all the data anyway, try selecting the table
in the Database Window. Then Copy (Ctrl+C), and Paste (Ctrl+V.) Respond to
the dialog that you want Structure Only, and supply a new name for the
table.

You can then delete the original table, and rename the new one.