Data unexpectedly transformed into Chinese characters
Posted on 2007-07-25
Got to work this morning - one particular record in my Access 2003 back-end "Job Log" table, which is the central table around which my whole system is built is all of a sudden filled with Chinese characters.
Last night's backup was OK, so I tried replacing that record after compacting and repairing and deleting the record in the Job Log table - but the weird thing was that all the related records in other tables were still there. I would have thought that the Cascading Deletes in the Referential Integrety business would have caused all the related records to go away.
Anyway I replaced the record in the Job Log, but when a user tried to access that job, all the data turned ito nubmer signs (not Chinese this time). I compacted and repaired again, and deleted the record again, but the related records are still in the other tables. Scary. Help. Is my world about to fall apart?
I did make some changes to the table yesterday - I changed a text field to a yes/no, but only after making sure the values were all "yes" or "no". Could this be a catastrophic error? Should I go to all related tables and manually delete all data associated with this one particular job number, then append the data from the backup?