Hi Bert,
I truly appreciate your help and advises. After all, spending time to answer IT questions and helping the other physicians after a whole busy day of seeing patients is a noble act. It was a long day yesterday. I was so frustrated last night when I log in after midnight. All of a sudden, everyone started to say that AC is built for small physician groups using a few computers only, as if connecting 30 computers to the server is unbelievable. I suppose pushing the limit is healthy for long term growth of AC.
To answer you questions, there are no specific laptops/towers that are more likely to have the SQL drop. Ordering tests and closing and reopen AC will put any client at risk. When the system is unstable, its kind of like you have to wait at the end of the line for your turn to get back in the system again. Rebooting the server did help.
Knowing that other groups with higher number of computers are having the same problem points to the problem of AC V5 and SQL, but not our network issues. Your suggestion of trying the SQL workgroup edition and contacting the SQL expert will be my next step. However, both are beyond my personal capability. I have to ask my IT guy to do them. I am not sure AC IT will guide us through the process of switching to the workgroup edition. Can you outline the procedure for us?
