I'm taking a guess at the product you're using. If it's the one I'm assuming, it's using views throughout. Like I said.. views won't guarantee it, just minimize it.

For the record, I've only been at 3M for 4 months, so I had zero input on your product.


>Craig
>
>I'd have thought that customers of "3M Health Information Systems" would know better! FWIW we use some of 3M's stuff for PDC coding.
>
>2 weeks ago in the UK I had a nice one. Tables became corrupt; I fixed them; they became corrupt again. After sleuthing a user admitted she was in the habit of "flicking her computer off whenever it freezes". Apparently it freezes during printing from Word sometimes; turning off and on is quicker than waiting for it to "unfreeze". I kid you not.
>
>So I added a facility to our app so that if it terminated abnormally, users would have to ring the hospital helpdesk to get back on. Guess what? Calls came in at about one every 2 hours. we learned that this habit had spread all over the hospital with users flicking computers off or using Task Manager rather than closing properly because "everybody is doing it" or "I thought that is what you do". These users had had defined Windows Training less than 6 months ago.
>
>I guess that falls into the "stupid user" category.
>
>FWIW, I see it as a tribute to the VFP6 dbf that there was so little corruption. If you did that with an Access database, you'd be looking for the backups.
>
>Regards
>
>JR