I have an Access97 database being used by 5 users over a WINNT network. Each user has the database open all day. About 1 or 2 times a week the database loses its connection to the server and some data is lost. The network itself however does not go down as no other networked apps go down. It seems to just affect access. If I close access and instantly reopening it everything works fine.
I also have another team using it over a Novell network with no problems in six months.
Is there some Win NT setting that is timing out my connection?
I don't want to split the database due to speed (but I know it would overcome the problem). I'd like to see if someone knows why this happens only under Win NT.
I also have another team using it over a Novell network with no problems in six months.
Is there some Win NT setting that is timing out my connection?
I don't want to split the database due to speed (but I know it would overcome the problem). I'd like to see if someone knows why this happens only under Win NT.