Slow Running Macro

December 23, 2006
We are exploring your trial version of the OLMonitor. It has the potential to be extremely useful for us. We are encountering a problem where it takes the macro about ten minutes to run and bring up the overdue log. It does not seem to be a problem when the administrator is logged on to the program but when I log on it takes ten minutes. The administrator seemed to think it might be the smarterm and I contacted them about two weeks ago. They are still working to try to figure something out. Since we only have about two weeks of the trial left, I thought I would contact you to see if anyone else had encountered this type of problem.

The program uses the registry to store settings and send a few status messages. Sometimes Windows XP/2000 can be a little pesky about allowing reading/writing from the registry when the user does not have adminsitrative rights. This problem can be compounded if IT has implemented extra security policies. There are a few solutions: Fix windows: always logon as admin(obviously this might not be practical but it is the simplest), increase the user rights of the user in question. Or you can work around windows: save your options as ‘current user’ instead of ‘all users’. Windows usually does not mind if the current user modifies their own portion of the registry, it can get pesky when the current user starts trying to modify settings that affect all users. The drawback is that any setup or customization you do will be saved only for the current user and not all users of the pc. You can however export your settings from the option screen and import them again every time a new user wants to use the program. One thing to note about using the ‘current user’ option is that many times the windows network will save your settings on the server, and therefore if you were to logon to a different station as that user your settings would be accessible there. Finally the ultimate workaround to the windows registry problem is to not use the registry at all. This is an option which I have just added, to allow you to store your settings in an .ini file instead of the registry. The .ini file is stored in the program folder and thus any settings you save to the .ini file can be accessed by any user of that pc. To change the ‘current user’, ‘all users’, or ‘ini file’ option run the program and click options, you will find it under the ‘Misc’ tab of the options window. After clicking ok you should close and restart the program.
The ini option is the newest and there may be some minor issues with it’s implementation. However during my testing it functions with no problems so I encourage you to try it and see how it works for you.