System Resource Exceeded

[Gkirkup]

I have a serious problem with a big application. When the users have two or more big forms open, they get a 'System Resource Exceeded' error. This is in Access 2010. However, we used to do this all the time in Access 2003 and never got an error. Does Access 2010 use memory differently?
What can I do to eliminate or reduce these errors?

Robert

 

[DavidAtWork]

Putting the possible memory issue to one side, what's your database setup i.e. is the application split FE/BE, if so what's the BE?

David

 

[Gkirkup]

David:
Yes, the database is split. I don't understand your question as to what is the back end?

Robert

 

[DavidAtWork]

G, I was just asking if the BE was Access or SQL server. If the database is split then I'd suggest it's most likely the front end file that must be causing the problem. How many records are involved when these main forms are open?
Other things to consider:
How many forms do you have running at any one time?
Do these forms contain lots of graphics?
Does the 2003 file have the same form content and functionality as the 2010?

David

 

[Gkirkup]

David: The problem started as soon as we moved from Access 2003 to 2010. Now we have memory problems when users have two or three forms open, some with many queries driving subforms. It's a real problem, as users like to keep forms open and switch between them. They can no longer do that.

Robert

 

[Gkirkup]

Access 2010. Split database. accdb database.

Robert

 

[David R]

Crystal is a spammer account, repeating old questions. Please ignore.

 

[ions]

I googled 'System Resource Exceeded' and got the below. It sounds like what you are experiencing.

http://support.microsoft.com/kb/2726928