System Locale

[Chris L]

Hi,

Can someone help me with this. I created my database with Access 2003
(English version) with my system locale set to English (United States) and I
have the data in 3 languages, i.e. English, Japanese, and Chinese.

The problem is that when I input a japanese string into a memo field on a PC
which has the system locale set to Japanese, it always gives this error
message "Write Conflict - This record has been changed by another user since
you started editing it. If you save the record, you will overwrite the
changes the other user made...." with the "Save Record" button disabled.

The strange thing is that when the PC with the system locale set to "Chinese
(P.R.C)" there isn't any problem inputting Chinese string. Another thing is
that the problem only occurs when the record is about to be saved into the
memo field. Text field doesn't have this problem.

Doesn anyone has any idea how to solve this. It is very inconvinience to
keep on changing the system locale as it requires restart.

Regards,
Chris L

 

[Tom Wickerath]

Hi Chris,

I don't know if this will help you, but it's something I recommend as far as
the Memo (or Hyperlink or OLE Object) data type is concerned. Try breaking
this field out to a separate table, related 1:1 to your existing table.

Two good reasons to isolate memo, OLE Object & Hyperlink data types include:

(ACC2000 Table Corruption After Referential Integrity Checks
http://support.microsoft.com/?id=296389

and

"A limitation to record-level locking is that users will not be notified
when another user is locking the record. “Also, record-level locking is not
enabled for Memo data types."

Source: http://support.microsoft.com/kb/275561, under the title:
"Record-level locking".


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________