Corrupted characters in MakeTable Result

[susanmgarrett]

I created a query that involved an IIF statment:

cattext: IIf(IsNull([parentcatdesc]),([categoryDescription]),([parentcatdesc]) & " (" & [categoryDescription] & ")")

When I view the query, it looks fine.

I changed the query to MakeTable and created a table.

When I view the table, the concatenated field appears as an Asian character:

椆0 (50S)

If I export the query, I get the same results viewing the data in an excel spreadsheet.

Am I dealing with database corruption? Did an errant keystroke change languages on me? The rest of the problem appears to be English and my settings are in English.

Does anyone have a clue as to what's happening? I've never seen this before.

Thanks!

Susan

 

[NPUser]

I have that happened in the past. I have a feeling you may have some memo fields or textboxes with lots of characters setup as indexed field(s). It might be these two fields [categoryDescription] and [parentcatdesc]. If so change the index properties of these field(s) to no and give the query a go to see if that makes any difference.

A following link might interest you:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;302525

Hope this helps.
sa

 

[neileg]

It may be unrelated but I would have written the calculation as follows:
cattext: IIf(IsNull([parentcatdesc]),[categoryDescription],[parentcatdesc] & [categoryDescription])

But it could be restated this way:
cattext: Nz([parentcatdesc],"") & [categoryDescription]

 

[jaydwest]

Question

Was your database originally an Access 97 or less and now running in Access 2000 or more?

I have had this problem in an old database that was originally written in Access 2.0 and is now running in Access 2003. I believe in Access 2002, MS started using unicode instead of ASCII and I suspect (although I have not researched it) this may be the source of the Japanese characters.

Unfortunately, I have tried all the tricks I know to resolve the issue but have not been able to yet.

Good Luck