On 13 Dec 2006 06:07:58 -0800, "Another_Access_Dummy"
<jeralee2@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.
Quote:
>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.
