Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Repair/Compact frequency, corruption?

Status
Not open for further replies.

Susanhopes

Technical User
Jun 27, 2005
17
US
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
 
I forgot to say that we repair and compact about once a month. After this latest episode we're on an every-other-week schedule. We shall see if it helps. Prognosis?
S
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top