Backend db is damaged when 4 users are logged on

[reidarT]

I have an application, fe on local machines, be on server with a Novell
network
Users log on using the mdw-file. The application works fine most of the
time, but when a 4th user is logged on it always destroys the be mdb-file
so bad it can not be repaired.
This happens frequently once a week when the 4th person is logged on.
All machines are identical and the network system is Novell.
This is a tremendous problem and the users loose faith in the system.
Is there anythng to do, like increasing files, buffers, handles ??? in any
way.
There are about 150 new records every day, and a continous form with all a
the 150 records are constantly open almost all the time of all users.
I have a feeling that the system crashes more often in the
Novell -enironment than in a windows -environment.
regards
reidarT

 

[PC Datasheet]

Is the 4th person always the same person? Determine if the problem is
related to the 4th person or the system by intentionally keeping one of the
first three users out of the system so that only two of the first three and
the 4th person are the most on the system at the same time. If the system
still crashes, the problem is most likely with the 4th person. If it does
not creash, the system is overloade with four users for some reason. Going
back to my original question, if the 4th person turns off his computer
without closing the database, the database will become corrupted. Check on
his operating procedure.