Search Key was not found (1 Viewer)

Mr. SLP

Registered User.
Local time
Today, 07:17
Joined
Dec 23, 2017
Messages
56
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

Premier Pale Stale Ale
Local time
Today, 08:17
Joined
Oct 17, 2012
Messages
3,276
My first thought is database corruption. I assume you've tried a compact and repair? What method did you use to attempt the delete?
 

Mr. SLP

Registered User.
Local time
Today, 07:17
Joined
Dec 23, 2017
Messages
56
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

Premier Pale Stale Ale
Local time
Today, 08:17
Joined
Oct 17, 2012
Messages
3,276
Sounds like you'll need to go through the steps ridders provided.
 

Mr. SLP

Registered User.
Local time
Today, 07:17
Joined
Dec 23, 2017
Messages
56
Just what I needed Ridders!... thanks guys.


Sent from my iPhone using Tapatalk
 

isladogs

MVP / VIP
Local time
Today, 12:17
Joined
Jan 14, 2017
Messages
18,186
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

Registered User.
Local time
Today, 07:17
Joined
Dec 23, 2017
Messages
56
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

Premier Pale Stale Ale
Local time
Today, 08:17
Joined
Oct 17, 2012
Messages
3,276
Meh, unless you know how to read them, Kanji are pretty hard to tell from Hanzi.
 

Users who are viewing this thread

Top Bottom