Susanhopes
Technical User
I'm running a large, replicated, permission-secured system that serves three programs, and is based on PCs. No server in-house, we're a small nonprofit and try to keep it simple. We occasionally note that data has been "lost." For example, a user puts in a set of birthdates for new staff, then looks a few months later and the fields are blank. We're ruled out instances in which that copy (it's the most remote and problematic of our replicas being in an area that gets a lot of lightning) failed and was replaced, and when I've made major design changes that required a fresh replica to be spun out.
This is not the only time we have run into such things. Most recent weirdness is the occasional lapse into case-sensitivity in the search function in a form. Happens in both the Master and the Replicas. Then it goes back to the way it was before without any steps being taken.
My best user just told me about searching for a much-populated and well-established record by ID number, an auto integer field, in most-used form, and she gets the error message "the value you entered is not valid for this field", but then it brings up the record anyway. And it doesn't do this for every record.
Have I got corruption, and if so, how much do you suppose there is? I dread moving everything to a new platform b/c the security is such a hassle to set up. We have a *lot* of objects to secure. This is kind of making me nuts. Ideas, please? Thanks everyone!
Susan
This is not the only time we have run into such things. Most recent weirdness is the occasional lapse into case-sensitivity in the search function in a form. Happens in both the Master and the Replicas. Then it goes back to the way it was before without any steps being taken.
My best user just told me about searching for a much-populated and well-established record by ID number, an auto integer field, in most-used form, and she gets the error message "the value you entered is not valid for this field", but then it brings up the record anyway. And it doesn't do this for every record.
Have I got corruption, and if so, how much do you suppose there is? I dread moving everything to a new platform b/c the security is such a hassle to set up. We have a *lot* of objects to secure. This is kind of making me nuts. Ideas, please? Thanks everyone!
Susan