not a valid bookmark

  • Thread starter Thread starter NAS
  • Start date Start date
N

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.
 
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.
 
That worked great. Thank you.

Allen Browne said:
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.
Click to expand...
 
Back
Top