Memory leak when Access continually connects to database files


Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.


When Microsoft Access (MsAccess.exe) or a custom solution continually connects to Access database files (.mdb or .accdb) through the Access ODBC driver and the OLE DB provider (Microsoft.ACE.OLEDB.12.0), the memory usage of the Access database engine keeps increasing until the process is completed.


This issue occurs because the Access database engine continuously allocates memory to run insert, update, and delete records in the Access database files. The Access database engine isn't intended for use with high-stress, high-concurrency, 24-hour-a-day, or seven-day-a-week server applications.


To work around this issue, regularly restart the applications or the computer.