Ordering tests, sending prescriptions and switching between patients sometimes triggered the detachment from the SQL data. Closing and then reopen AC program will frequently cause the problem when the network is busy. Our AC data is 800MB. We will certainly try to delete messages as suggested by Jon.
Our IT has monitor the primary server (2003 with 4 GB RAM) the whole day and saw no spikes in the processor usage or RAM. We now dedicate this primary server to hold AC and the scanned patient data only. We use a second Server (Windows Server 2000) as the terminal server for the 8 clients to log in from the second office. All the laptops in the primary office and this second server then connect P-2-P to the primary server that holds the AC and import data. We switched some of the older laptop clients with newer ones that carry larger RAM and faster processors. We'll see what will happen next week when the offices are back to regular schedule.
