Unknown Access Database Engine Error

[knpaddac]

Recently while entering some data via a subdatasheet while in the datasheet view, one of my records in the datasheet suddenly turned to what appears to be Chinese, and ever since, when I try to sort the table that was in Datasheet view by a date field, I get the message "Unknown Access Database Engine Error."



Can anybody help me to figure out how I would determine what the issue is?

[ranman256]

Did you set the font in database options? I'm a Times Roman guy.
did you repair/compact?

[isladogs]

The 'chinese' characters almost certainly mean one or more records is corrupted.
So if you try and sort the data, Access will report an error
Do you have a backup you can use to restore the data?
If not, you will need to identify the corrupted records, delete and replace them.

It's very unlikely that compacting will solve your problem

[knpaddac]

I found the record but when I try to delete it I get the message "the search key was not found in any record."

The 'chinese' characters almost certainly mean one or more records is corrupted.
So if you try and sort the data, Access will report an error
Do you have a backup you can use to restore the data?
If not, you will need to identify the corrupted records, delete and replace them.

It's very unlikely that compacting will solve your problem

[isladogs]

Only one record. Good.
How are you trying to delete it?
Using a delete query or directly in the table?

[knpaddac]

In the table. Might need some guidance on making a delete query.

[Micron]

Copy the corrupt table.
Delete the original.
Use make table query to make a new table from the copy. I would not keep using the problem table.
You should back up the db before doing this on any important version/copy.
But you would know that from reading my signature, right?

[knpaddac]

Correct. I would have certainly done that.
So you are saying to make a copy of the table, then delete the corrupted record from the copied table? Then from the copied table make another as the replacement?

Copy the corrupt table.
Delete the original.
Use make table query to make a new table from the copy. I would not keep using the problem table.
You should back up the db before doing this on any important version/copy.
But you would know that from reading my signature, right?

[isladogs]

You may find this link useful for explaining the approach in more detail
http://www.blueclaw-db.com/table_cor...d_database.htm

I did ask if you had a recent backup.
If not, I'm fairly sure you will be doing that regularly from now on.

Good luck

[Micron]

So you are saying to make a copy of the table, then delete the corrupted record from the copied table? Then from the copied table make another as the replacement?

No. I see that I wasn't real clear.
Copy the table. Use a make table query to make a new table from the old . Either use an append query or try copying/Paste Append from the copy to the new table.
Delete the original table.

This assumes the problem is with the table and not the single record you have - which is why I think the safer bet is to use an append query.

[knpaddac]

Thank you everybody for the assistance. I think that I have gotten it figured out. Currently going back through all my queries to adjust for the new table/name.

[Micron]

Wondering why your new table doesn't have the same name as the original...