We have implemented a package application running on Access ’97. We are attempting to run this on W2K Server through Terminal Services. We are having troubles with frequent (2-3 times/day) data corruption and database needs to be repaired. We have about 30 connections to the database. Some of the advice we have received ranged around disabling opportunistic locking and using single high bandwidth NIC cards.
So far, none of this has stopped the corruption. Are there any other “tricks” that anyone has come across to prevent the corruption?
Regards,
Mark
