Database corruption - Chinese characters

[Another_Access_Dummy]

I am getting database corruption more frequently than is ideal. I have
a form used in a call center environment with about 5-10 users at any
given time. The application is split between front end and back end
and the back end resides on a network server. Each user has their own
copy of the front end.

During my searching, I have discovered that fast scrolling may cause a
record to change to Chinese characters and become corrupt. Does anyone
know why this happens?

Also - it's not just when scrolling. I just had a user go back in to a
record he had already saved and try to fix a typo in the comment box.
He immediately received an error and everything changed to chinese.

Any suggestions? I have my users set to "No Locks" because on the
"Edited Record" locking strategy, we had alot of "Currenty Locked -
cannot update error". We still get those, but I'm not sure if this has
anything to do with the problem or not.

[Tom van Stiphout]

On 13 Dec 2006 06:07:58 -0800, "Another_Access_Dummy"
<je******@yahoo.comwrote:

I think once is more than ideal.

Perhaps some of those fields are memo fields, which corrupt more
easily than text fields. See if you can convert to text
(maxlength=255)

Turn off Name Autocorrect.

-Tom.

>I am getting database corruption more frequently than is ideal. I have
a form used in a call center environment with about 5-10 users at any
given time. The application is split between front end and back end
and the back end resides on a network server. Each user has their own
copy of the front end.

During my searching, I have discovered that fast scrolling may cause a
record to change to Chinese characters and become corrupt. Does anyone
know why this happens?

Also - it's not just when scrolling. I just had a user go back in to a
record he had already saved and try to fix a typo in the comment box.
He immediately received an error and everything changed to chinese.

Any suggestions? I have my users set to "No Locks" because on the
"Edited Record" locking strategy, we had alot of "Currenty Locked -
cannot update error". We still get those, but I'm not sure if this has
anything to do with the problem or not.