I've developed a fairly large Access 2003 database (1370 queries, 184 forms, 129 linked SQL Server + local tables), and some of the forms/queries/reports, etc. are used for quoting jobs. The people that use this part of the program (and only those people) are getting the following error: "2004 There isn't enough memory to perform this operation. Close unneeded programs and try the operation again."
The parts of the program that have error handling record the error when it happens, but the users get kicked out of the program and the error doesn't get recorded when the error happens and there is no error handling. Judging both by the errors that get recorded and the user's complaints, the error is happening more and more frequently. Out of the errors that were recorded, the error happened as follows (1 error in October, 1 in November, 0 in December, 4 in January, 9 in February, 14 in March, 22 in April).
This happens to users using the latest Service Pack (SP3) and with users who aren't using the latest Service Pack. This happens when they're using different parts of the program (i.e. it happens on different forms and when they are doing different things with those forms). I made a change to the forms and reports that they use back in December after which the problem started to happen more and more often. The error only occurred twice (that I'm aware of) before I made this change to the program. I tried saving to text and loading from text all of the forms and reports they use, and I tried importing all objects into a blank database. How can I prevent the error from continuing to occur?