Error: "The search key was not found in any record"

[SarahO]

Help! A very strange record has materialised in my database. Consisting of characters like these:
༏｀䳾䬲 No 00:00:00 佔㌳ 7744 00:00:00 00:00:00 N/AŸÞ 呌ㅏＲ㋾〰 Yes Yes No Yes 00:00:00 00:00:00 00:00:00 00:00:00 Yes Yes Yes 00:00:00 〶〹Ｓ叾䅔⁂佐䱏删乕丠塅⁔䅄⹙倠䕒䅐䭃匠呅唠⁐义佃剒 0 00:00:00 䍅䱔ｙ䓾
The database is linked to an excel spreadsheet which updates the database. When I try to delete the record I get a message;"The search key was not found in any record" I can't even overwrite the field with proper data either. Please can anyone please explain to me how this record has appeared (in simple terms - I am a very simple person) and how do I get rid of it?

 

[ejstefl]

Try compacting and repairing your database. Whenever I get this error, it usually means that the record has somehow become corrupt.

 

[SarahO]

Sorry for the delay in replying. This worked and the offending record has now gone.
Thanks
Sarah