Corrupt Characters

[ions]

My client is reporting corrupt characters cropping up in fields. These characters appear as Asian Characters. They only corrupt one record.

This happens very seldom. In fact, it hasn't happend for about 2 months and today it happend again. Their was no change to the database.

Is this a network problem? Network noise corrupting data?

Thanks

 

[GMLWORLDCHAMP!]

Networked mdb...

If this is a networked Access database, what may have happened is that while the database was being compacted/repaired, another user tried to launch the application, causing an interruption of this process and that can definitely create many table corruption issues.

Other symbols to look out for include, the pipe (|), the small white empty box, and octothorps (#)...pound signs...

The pound signs and empty white box symbols especially are indicators of corruption in a table.

In a standalone database, this corruption could be the shutting down of a form or report that you have protected with underlying VBA or stopping a querying process prematurely.

 

[ions]

Hi GML

That is not the case. My client only compacts and repairs in the early morning when there are no users in the office.

Peter.

 

[The_Doc_Man]

First question is, "Asian characters" - is this a real comment or an off-the-wall comment? There is such a thing as having the wrong local settings causing the system to default to an alternative character set. On the other hand, if the person in question says "it's like Asian to me" it COULD be the same as the older "it's like Greek to me." You have to decide which.

If I recall correctly, most Asian character sets are UNICODE based. So if you are using the wrong UNICODE set, you might be seeing the result. Is that the wrong code page or something like that? I rarely play with that particular setting but I know it exists.

 

[shadow9449]

First question is, "Asian characters" - is this a real comment or an off-the-wall comment? There is such a thing as having the wrong local settings causing the system to default to an alternative character set. On the other hand, if the person in question says "it's like Asian to me" it COULD be the same as the older "it's like Greek to me." You have to decide which.

If I recall correctly, most Asian character sets are UNICODE based. So if you are using the wrong UNICODE set, you might be seeing the result. Is that the wrong code page or something like that? I rarely play with that particular setting but I know it exists.

Doc:

I've seen it myself. The writer literally means that Asian characters will appear in text fields when a database becomes corrupt.

SHADOW

 

[DataNumen]

Hi,

I'm afraid that your client's database was corrupt. You can try our product Advanced Access Repair to repair it. It is a powerful tool to recover data from corrupt or damaged Microsoft Access databases which supports to repair Microsoft Access 95, 97, 2000, XP and 2003 databases.

Please visit http://www.datanumen.com/aar/index.htm for detailed information about Advanced Access Repair.

And you can also download a free demo version at http://www.datanumen.com/aar/aar.exe

Alan Chen
DataNumen, Inc. - World leader in data recovery technologies
Website: http://www.datanumen.com
Fax: +1-800-9917-FAX (US Toll-Free), +852-31829286 (HONG KONG)