Search Key was not found

[Mr. SLP]

Something went haywire and I have a record in a table that has various fields swapped out to be written in crazy symbols (like Japanese). Any time I try to write over the cells or delete the record I get a message saying “Search key was not found in any record.” Suggestions?


Sent from my iPhone using Tapatalk

 

[Frothingslosh]

My first thought is database corruption. I assume you've tried a compact and repair? What method did you use to attempt the delete?

 

[isladogs]

You have one or more corrupted records so searches, sorts etc fail with that error message.
Unfortunately compacting will not solve the issue

This link may assist you with a method for fixing the problem
http://www.blueclaw-db.com/table_corrupted/repair_corrupted_database.htm

 

[Mr. SLP]

My first thought is database corruption. I assume you've tried a compact and repair? What method did you use to attempt the delete?

Yeah already tried that. I’ve tried every way I can think of... through a form, directly through the table, and through a delete query. No luck.


Sent from my iPhone using Tapatalk

 

[Frothingslosh]

Sounds like you'll need to go through the steps ridders provided.

 

[Mr. SLP]

Just what I needed Ridders!... thanks guys.


Sent from my iPhone using Tapatalk

 

[isladogs]

Probably only one record. Have you fixed it?

The characters are often described as 'Chinese' rather than Japanese
I've no idea whether either is correct but would be interested to know what the equivalent is for those using Chinese as the Office language

 

[Mr. SLP]

Yeah it was just 1 record. It was an easy fix. I would like to think I would of come to that procedure myself but it would of taken a heck of a lot more time... yeah don’t know why I said Japanese. It was a toss up for me lol


Sent from my iPhone using Tapatalk

 

[Frothingslosh]

Meh, unless you know how to read them, Kanji are pretty hard to tell from Hanzi.