By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,805 Members | 1,427 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,805 IT Pros & Developers. It's quick & easy.

Database corruption - Chinese characters

P: n/a
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.

Dec 13 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Dec 13 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.