I have a vba function that triggers a sequence of dozens of sql statements. These statements each effect hundreds of thousands of records. I am running it on a pc devoted solely to this application. The PC has about 1gb of memory.
The function DOES run. It takes about three hours to finish. However, while it runs Access does not display forms properly. For example, it cannot repaint a form if you change it. And if you interact with Access too much, the function crashes.
It would be fine with me if the function took longer to run. However, I DO want it to be more stability. Can I somehow tell Access not to devote every atom of memory to this task, and to take longer to complete it??
The function DOES run. It takes about three hours to finish. However, while it runs Access does not display forms properly. For example, it cannot repaint a form if you change it. And if you interact with Access too much, the function crashes.
It would be fine with me if the function took longer to run. However, I DO want it to be more stability. Can I somehow tell Access not to devote every atom of memory to this task, and to take longer to complete it??
