Alas, last week suddenly my EMR suddenly slowed down appreciably. For those of you who don't know the EMR that I use, I use a MS Access EMR not unlike AC with a Jet backend, and I've been working on for 18 years. I've rarely had issues with slowdowns in the past.

This slowdown occurred ironically after I increased the RAM memory in half of my computers from 750MB to 2 to 2.5GB, including the computer that housed the backend tables. At first I cleaned out the softwares that automatically load into memory, but this offered no appreciable speed improvement.

Yesterday I did the following which made amazing increases in speed and efficiency of my forms and reports:

1) I put the backend into the root directory, meaning from "c:\program files\zfilemds\zfilemdsbe_cc.mdb" to "c:\zfilemdsbe_cc.mdb".
2) I switched the backend location from the computer where my biller works to the backend where the HP that I recently performed massive fixes to, including setting up fast SATA drives, 3GB RAM memory, and adding a 600Watt power supply. This backend is also rarely used, if at all.
3) I ran System Mechanic 7, which comes free when one buys the retail version of ZoneAlarm and it fixed and optimized my WinXP installation from my registry to my file system. Several hundred optimizations were performed, besting what I had done previously by far with my 2004 versions of Registry Mechanic and System Cleaner both of whom I'll put to rest now.

I can't believe the difference in speed... Just some thoughts to ponder if your system seems slow.

Cheers,
Al

Last edited by alborg; 04/30/2008 2:02 AM.