Strange characters

[Mary]

I have a table with a memo field. I have used it in queries previously and
it was returned just fine. Occasionally, though, it returns characters that
I don't recognize such as 鈉‡ - does anyone know what is going on here?
Thanks.

 

[John W. Vinson]

I have a table with a memo field. I have used it in queries previously and
it was returned just fine. Occasionally, though, it returns characters that
I don't recognize such as ?? - does anyone know what is going on here?
Thanks.

It's quite likely that the database - this memo record in particular - is
corrupt. Make sure you have a good backup, preferably from before this error
turned up; if not, make one NOW.

See http://www.granite.ab.ca/access/corruptmdbs.htm for causes, symptoms and
possible cures for this kind of corruption.

 

[Mary]

Thanks - these data are stored in SQL and imported into Access for some
analysis so there shouldn't be a problem there. But these fields work quite
well most of the time in queries - it's only occasionally that these odd
characters appear in query results.

 

[John W. Vinson]

Thanks - these data are stored in SQL and imported into Access for some
analysis so there shouldn't be a problem there. But these fields work quite
well most of the time in queries - it's only occasionally that these odd
characters appear in query results.

Imported? Or linked?

If linked, I'd suggest dropping and recreating the links. If imported... I
have no ideas!