George,
Are they accessing these tables from some other program? Like Excel or Access or dBase?
>We have a sticky problem at one of our client's sites. They are experiencing some odd behavior in several tables. It seems that integer fields are mysteriously changing values by 128 (that's right, 2^7).
>
>Has anyone ever seen this happen to them? The clients are getting upset, and rightfully so. So far, we have been able to correct the data by looking at backup tapes. But this is a band-aid over the true problem. We are seeing this happen in multiple tables and with different fields.
>
>Oh, one more thing: we tried putting update triggers on the data, but the triggers haven't fired. The records affected were added 2 years ago or so. They hadn't changed at all until a few weeks ago. Our system is set up in such a way that these records really never change.