not a valid bookmark

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.
 
A

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.
 
N

NAS

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top