>>I'm confident this was not a case of sabotage but I will review exactly what file rights the average user has and tighten that up if needed.
>
>Whoa! I didn't say sabotage! It could easily be a simple mistake! The user that did it may not even be aware of what cause it had. Now that it's done and the effect is evident, they probably don't want to own up now, in any case, especially if you start a witch hunt for a saboteur.

Well, I can tell you this about the damaged file. It is the same as the real file though the first 58202 records (based on a casual inspection). Then there are three records of mostly zeroes. Then nothing. The real file has 931247 records.

So it is not some errant Excel file etc. One could not create this file with VFP because two of the final records have a zero primary (candidate) key. Besides no one here uses VFP except for me and my partner.

I think it was some kind of network-server glitch.

I'm certainly not going to be accusing anyone! :-)

I think all the cursors are already going to the tmpfiles folder on each local disk.

Peter


>I prefer the user not have create and delete rights. They can create cursors etc in their tmpfiles folder.