search key not found?

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

A record has gotten screwed up in a table. In the key
field somehow I now have "WHIT00" (a small square at the
end). That was supposed to be a 2 i.e. WHIT002. When I try
to change it in the table and leave the record, I
get "Search key could not be found in any record". I'm not
trying to do a search, just correct the messed up data. I
get the same message if I try to delete the record.
Anybody know how my data could have got that little
square, what it means, what the error message means, and
how do I fix or delete it?

Thanks

Rick
 
A record has gotten screwed up in a table. In the key
field somehow I now have "WHIT00" (a small square at the
end). That was supposed to be a 2 i.e. WHIT002. When I try
to change it in the table and leave the record, I
get "Search key could not be found in any record". I'm not
trying to do a search, just correct the messed up data. I
get the same message if I try to delete the record.
Anybody know how my data could have got that little
square, what it means, what the error message means, and
how do I fix or delete it?

Thanks

Rick
Click to expand...

Your database has become corrupted, probably with a bad index on this
field. MAKE A BACKUP, NOW! You may need it!

See the suggestions at Tony Toews' website

http://www.granite.ab.ca/access/corruptmdbs.htm

You may need to create a new .mdb file, and import everything *except*
this table. Create this table, empty; link to the corrupt database,
and run an Append query appending everything *except* this record. It
will need to be reentered manually.

John W. Vinson[MVP]
 
It won't let me delete the record. Gives me that same
message.
Click to expand...

Reposting from yesterday:


Your database has become corrupted, probably with a bad index on this
field. MAKE A BACKUP, NOW! You may need it!

See the suggestions at Tony Toews' website

http://www.granite.ab.ca/access/corruptmdbs.htm

You may need to create a new .mdb file, and import everything *except*
this table. Create this table, empty; link to the corrupt database,
and run an Append query appending everything *except* this record. It
will need to be reentered manually.

John W. Vinson[MVP]

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

Search Key not found in any record - error message 18
Search key not found 2
Search key not found 2
Error - "Search key was not found..." 1
Search Key Was Not Found 1
When I tried to delete the record, I got a error message! Pls Help 4
Error importing from Excel message "The search key was not found" 1
The Search Key was not found in any record... 0

Back
Top