Chinese Symbols in Access 2010

[howlettb]

I have created a database in Access 2010 which has a "Main" form comprised of two parts. The top half has basic demographic information, and the bottom half has household members (which can be clicked on to take you to their individual record). Both halves access the same table. Sometimes when an employee adds a person to the bottom section ... Chinese symbols occur. I know how to correct these symbols fairly quickly ... but for the life of me ... I can't figure out how to stop them. It can happen once/month ... or several times a day. Any ideas???

[ranman256]

what font is the form set to?

[howlettb]

The top part is Calibri ... the bottom is Calibri (detail). Would that make a difference??

[ranman256]

it could have Chinese in it.

[howlettb]

I believe the Chinese represents a corrupted file.

[Mahendra1000]

How you are gonna fix those symbols?

[howlettb]

You have to get behind the scenes ... run compact and repair (which puts the corrupted line at the bottom) ... and then remove the line. Sometimes if you don't run compact and repair ... it won't let you delete it. If you don't remove the corrupted file ...it will start affecting the database (drop down boxes won't work, etc).

[NTC]

Is there a query involved that is calling a form's field value?

[howlettb]

I'm not 100% sure what you mean ... but I think yes. The Main form is made up of 2 subforms. Each subform is accessing the same table (MainT) ... and each has a query that is putting paremeters on a field. I think part of the problem is that I'm using the same table in each of the subforms ... but not sure how to do it any other way.

[peiyezhu]

can you upload a file for research？

[June7]

Two subforms bound to same data source is unusual and can cause issues if both forms are trying to edit same record. Why would you have this arrangement?

If you want to provide db for analysis as suggested by peiyezhu, follow instructions at bottom of my post.

[JeroenMioch]

I used to have the same issue in one of my databases.
Once i let a Chinese woman look at the characters and she told me she could not decipher it.
I didnt ask her if it is just another language or that the letters and numbers didnt make any sense
It is my believe that the corruption is a result of a record being edited by two instances at the same time, either by users or programmatically like VBA or SQL.

What i did was put a recordlock in place as described here : http://www.databasedev.co.uk/multi-u...d-locking.html
I never saw the Chinese characters again but i must say i did compact & repair first. So im not sure which one helped.
Recordlock can be a good idea anyway when you have multiple users that can coincidentally access the same record.
The pop-up that access does "This record is edited by another user, do you want to save or copy to clipboard" is confusing for users and results in loss of data.

[NTC]

Let me re-ask the question another way: do the Chinese symbols display in the query .... you see them you say in the form, but the form is displaying data from a query...so looking at the query results directly are you getting these symbols there?