the search key was not found in any record & Invalid Argument

[Paul]

Hi, I have a database which has been in use for 2 years. Now all of a
sudden when one particular user enter a date into a field all
information within that record the text changes to Chinese style
characters. Also I am unable to navigate to the next record as i get
'Invalid Argument' error warning.

The database is split into front end and back end but I am unable to
delete the record, I keep getting 'the search key was not found in any
record'. Can anyone help

[Allen Browne]

Hi Paul.

Take a look at the 3rd symptom in this article:
http://allenbrowne.com/ser-47.html#RowsShowDeleted

It explains how to create a table and import all the *other* records,
without referring to the bad one.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Paul" <burn...@hotmail.co.uk> wrote in message
news:3249653e-449b-4e70...@f16g2000yqm.googlegroups.com...

[paii, Ron]

"Paul" <burn...@hotmail.co.uk> wrote in message
news:3249653e-449b-4e70...@f16g2000yqm.googlegroups.com...

Your Back-end DB may be corrupted. Make a copy and do a repair on the copy.
If the table is fixed replace the BE with the repaired copy.

If the repair does not fix it and the table has a memo field, you may have a
corrupt memo. If so, do you have a good backup of the DB? Restore it. If no
backup you will need to recreate the DB then import all the objects except
the bad table. To restore the Table, create it in the new DB and copy the
good records.