Obučavanje
Certifikacija
Microsoft Office Specialist: Access Expert (Office 2019) - Certifications
Demonstrate that you have the skills needed to get the most out of Access 2019 by earning the Microsoft Office Specialist (MOS) Expert certification.
Memory leak when Access continually connects to database files
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.