field corruption

[crazybake]

I have posted this before, but can't find if this issue has been resolved...

I am using FM server on Win2K. I have a single database which is access by approx 5 users - all of which are NT4 users. In general, all is fine... howevewr, approx once per month, a user will attempt to perform a task (which we have not identified as a single task) and a date field will change so that every record will have this same date..

This is a db file in which usually only one of the five users will acess this date field. This field is either filled manually or by selecting via a button on a calendar. This user has mentioned that the screen will redraw and record by record (in list view) and the date field will change usually to the current day or to the next day.

There are several scripts which are used daily which refer to this field, but usually accessed by this one user..

I have seen posts where other users have experienced thius isssue... any resolve..

c

[Anatoli]

Are you using some security / access level / passwords?

Or there is bug in Loop in the script...

[DonH]

Tough one without seeing your scripts.

If this was SQL the solution would be obvious. It would mean you forgot to specify which record to update so every record updates with the same data.

For instance you say to update the date to 1/1/2004 but don't say to do this ONLY to record number 12. Every record gets updated in this case.

I'm not sure if that is what your problem is or not. But take a look and make sure you are not telling it to update all records.