Hi Bert,
I am sorry that I cannot get back to you earlier. We had multiple incidents of dropping from the SQL Exp yesterday. AC tech support logged in to our system again and clean up some old Access files in the server. He said that he will bring this issue to the developer.
You mention about checking the whole network. We have 2 un-managed switch, one Gigabyte switch connecting to the main server (Windows 2003), a back up server (Windows 2000)and majority of the laptops (Windows XP Home). Another 100MB switch connecting to printers and some other tower running AC. All except computers have 1GB RAM except one Dell Inspiron 1000 that can only take 500MB RAM. There are 3 older Dell Inspiron 1200 upgraded to 1GB RAM. They can run the AC program, but too slow to do the AC e-prescription. Do you think these 4 Laptops actually slow down the whole network?
The above network is connected via a VPN tunnel (using Sonicwall) to a second office with 9 computers and a second VPN tunnel to our billing company with 2 computers running AC. This set up was running fine using AC V4. The problem happens after upgrading to V5.024.
I really appreciate your input. I have contacted my IT concerning your suggestions. He is looking into a possible trial of the SQL server 2005. Another possibility is to remove all the computers from the 9 exam rooms, and let the doctors and nurses use wireless 4-6 netbook/Tablet at one time. However, I worry more about the stability of the wireless network.
