The customers were deleted from one workstation today. We are finished deleting customers for now, but I fear for the next time we have more customers to remove from our system. As far as I know, opportunistic locking was disabled at the time that Adagio was installed on each of the workstations. Adagio installation gave a warning about opportunistic locking and then asked if you want to disable it now, which we did. I don't know anything about file caching. We have XP Pro workstations on 2003 SBS server.

I know that Softrak always warns customers not to run Adagio on the server (which we don't), however, in this case if the network is the problem, would it make sense to delete customers from the server machine so that it read/writes without errors?

I keep hearing on this forum that deleting is not good and can corrupt data, not just in AR, but also Inventory. I really want to delete obsolete customers and inventory items. The idea of keeping these records forever and renaming them "Obsolete" seems to be not a very good long term solution. Those Obsolete codes will continually add up. And won't they slow down our searches and reporting? We'll always have to filter them out somehow because we really don't want to even know they are there. It seems so much cleaner and better organized to remove them.

Obviously, we can't risk destroying our data so if we have to keep our old records to prevent data corruption I guess we will do so.

Please let me know if there is a better alternative.