Chinese records!

[stephen81]

One of my database users set up a new record a few days ago, entered all the information etc. He's now gone to have a look at it and it appears to have been translated into Chinese or something! The text fields have changed to things similar to 潩の＀ㇾ′敆湲慤敬, the autonumber field has changed to 520099398 whereas it should be 5702 I think. The date entered has changed from 22/7/05 to 30/12/1899. Any ideas what the problem is or what could cause it?


Also, I've just been taking another look, and although the autonumber field is showing as 520099398, if I open the table and filter on that field with 5702, it filters down to that record. If I filter on the date entered using 22/7/05 it also retrieves that record, despite it showing 30/12/1899.

 

[Len Boorman]

Bit of a guess here but go to Control Panel and check regional settings, date and data format.

Sounds suspiciously like a pc problem rather that an access problem

You may have to dig deep in the pc settings

L

 

[stephen81]

Bit of a guess here but go to Control Panel and check regional settings, date and data format.

Sounds suspiciously like a pc problem rather that an access problem

You may have to dig deep in the pc settings

L

I'm fairly sure it's not the regional settings. It's only the one record. All the other records (before and after) are fine and we've not changed any PC settings. I've also checked it on my pc and I get the same nonsense. The regional settings are set to uk as they always have been.

 

[stephen81]

I also can't delete the record. When I try, it gives me an error message "The seach key was not found in any record".

 

[Len Boorman]

Okay

Looks like it is a single contaminated record probably caused by an attempted double edit.

Deleting the record is not possible as you have found out.

You need to copy all records except this one to a new table then kill the original table. You can then rename the new table to the old table name and all queries etc should then work okay.

If you are using a form to edit records then on the form properties there is a property for Record Locking. This should be Edited Record.

A record locking strategy is essential to avoid this sort of problem

L

 

[stephen81]

Thanks Len, that looks as though it will work fine. Sorry for the delay in replying. I've been away for a couple of weeks. I've added the record locking as suggested as well now.