Cannot delete records

G

Guest

In my database, I entered a couple test records. Now when I try to delete
them, I get an error stating "The search key was not found in any record."
How can I delete records after they have been saved into the table? I don't
have any permissions set to keep me from doing this.
 
J

John Vinson

In my database, I entered a couple test records. Now when I try to delete
them, I get an error stating "The search key was not found in any record."
How can I delete records after they have been saved into the table? I don't
have any permissions set to keep me from doing this.
Click to expand...

Sounds like database corruption. Try Tools... Database Utilities...
Compact and Repair; and check Tony Toews' corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

John W. Vinson[MVP]
 

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

Similar Threads

Record-Locking remains open after closing 0
When try to delete record, required field can't be null 3
How to eliminate records that are used to test a created database? 8
DELETE FROM a table WHERE... 1
Writing SQL code to delete duplicate records 0
Linked SQL Tables don't report Cascading Updates and Deletes 2
Record insert/delete anomaly 0
Can't delete a record 3

Top