Memory (RAM) use grows with Access 2007
Posted on 2011-03-15
When my Access 2007 accde or accdb starts, task manager shows allocated memory at 28m (28,000k). Over time (2 hours), useage can go up over 600m. Many might call this a memory leak.
I have searched for memory leak issues to no success.
I have validated that all calls to data sources are closed after use.
This is not a compact and repair issue.
Maybe I need code that releases resources when a form is closed?
The application is a basic FE-BE configuration. For users, the FE is an accde with tables linked to both an accdb and SQL server. All users have Access 2007 SP2 on XP, Vista, Windows 7 or Server 2003 with all updates and SP installed.
Suggestions on further research welcome. Solutions even better!