This morning I tried to run an Access 2010 query I made a few weeks ago and it prompted me for…. Well I don’t know since I can’t read Japanese, Korean or Chinese or whatever language it used. Looking at the query in design view shows the field name is now in some Asian language. All of the fields in the table still show their English names but in the designer one field is now called “[¿¿¿$¿¿¿$]” – hence the prompt for a parameter - the other fields in the designer still have their English names. The query is based on one table – MsysObjects – and it only uses 5 of the fields – I don’t remember which field is being translated although it was not one of the “OLE Object” types.
I have seen this automatic translation to an Asian language in Access data before but never in a field or other object name. I never found out what was changing data from English to whatever Asian language it was using although the problem was more frequent if I imported data from FoxPro tables. It also happened sometimes when multiple users were using the same Access DB. I started using adp projects for multi-user databases and haven’t had the problem with any of those.
I don’t make adp projects anymore since it seems like they are going to be dropping support for these in the near future. The DB I am having the problem with now is an Access 2010 accdb type. I have done multiple compact and repairs and like the problem with the Asian data it doesn’t help a bit. I am using Windows 7 Pro on a 64 bit machine although our IS department installed the 32 bit version of Windows. The Office 2010 version is also 32 bit.
Can someone please tell me why Access does this and how to stop it?