I have a fairly intensive application build on MS Access 2003. Often when the user is entering inforamtion, the CPU usage jumps to 100% and then the application crashes. Their computer has 512MB RAM and plenty of open hard drive space. Granted, the computer was fragmented pretty bad - 22% file frag. (which I'm cleaning up now), but I'm surprised that it would cause the application to fail.
Also, I have gone into the code module and checked to break on all errors, yet it crashed witout breaking.
So I have two questions:
1. Is it likely that fragmentation caused the application to crash
2. Can I limit Access to only calculate when a command button is pushed, rather than continously calculating. I have noticed that there is a calculation everytime a key is entered - even when type items into a memo box.
By the way - it NEVER crashes on my desktop (1 GB RAM). So I don't think it's an application issue per se.