Memory issues in 2010

[Gkirkup]

We recently moved from Access 2003 to Access 2010, and the users are having serious memory issues. Having open a couple of forms at once often results in an error message or a white screen. What can I do to free up more memory?

Robert

 

[Gkirkup]

Pat:
This is happening mostly on one large form. It's as wide as Access allows. Users will sometimes have other forms open and I have no control over that.
There is quite a lot of VBA code on the big form, so I take your point that it could be moved. How would I move - say - On Open code? Have that code in a module and then in On Open just a call to that function in the module? Would that save memory?

Robert

 

[Gkirkup]

Pat:
This is happening mostly on one large form. It's as wide as Access allows. Users will sometimes have other forms open and I have no control over that.
There is quite a lot of VBA code on the big form, so I take your point that it could be moved. How would I move - say - On Open code? Have that code in a module and then in On Open just a call to that function in the module? Would that save memory?

Robert

 

[Gkirkup]

Pat: Thanks, that is most helpful.

Robert