>We have an multi-user application with 4 active users. They are running Windows 95 in a Novell 4 Network. Their systems range from Pentium 166 to 233. The network lines range from 10 Base-T to 100 Base-T. The server has a Raid array which allows for very quick NW access.
>
>We believe that the error that we get is when two users are entering a form simultaneously.
>
>Some other symptoms of the general problem is that sometimes all records related to a transaction are saved but one numeric field in a header table is left blank ( not 0 ). Sometimes an invalid PK is stored. We get duplicate PK's, even though this is supposed to be prevented by the framework. What is odd is that if you look at the table in PK order the PK is in the correct place but it is a duplicate of a prior PK, almost as if there were some kind of index corruption.
>
>The users are complaining about slowness in the system. And it seems at times that we get random data corruption.
>
>Although, we have always had these problems, it seems they are occuring in epidemic proportions and now we have angry, frustated users on top of everything else.
>
>Hellllpppp.

Dan,
There was a thread on this very subject between 4 and 8 February. Do a search on 1709 and you should find some interesting leads. The error stems from the fact 2 users are trying to get access to the same view at the same time. The first thing you might want to do is opening the view NODATA so that it loads faster. The second is trap for the error, and RETRY.

José