Having a problem with my app. Everything runs fine, and system resources remain high and constant. However, whenever I manually enter any one of my Modules, the system resources on my computer (and those of my clients) drops dramatically. Often times the system resources will drop down to 10%. Eventually I have a fatal error and the user is forced to exit Access and re-enter.
I have double and triple checked all of my variables and recordsets. I have declared them properly and 'emptied' them at the end of the procedure. I have set and loaded my recordsets properly and R.Closed them at the end. I do not have any global variables in the app. What could be wrong?
Help would be appreciated.
Pat
I have double and triple checked all of my variables and recordsets. I have declared them properly and 'emptied' them at the end of the procedure. I have set and loaded my recordsets properly and R.Closed them at the end. I do not have any global variables in the app. What could be wrong?
Help would be appreciated.
Pat
