Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
The productions database is 32 bit with a SQLExpress backend.
MS Access Memory Issue
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Programming in Access 365 but it is a 32-bit access front end with a SQL Express backend. Been using this database for years with no issues. All of a sudden starting approx. last Monday 12/12/2022 we started getting out of memory errors on the client side. Users started getting it randomly over 2 or 3 days as if it was an update.
If I open the database and watch task manager, as I open forms and close them, I see the memory usage go up when the form is opened as expected but it never goes back down to where it started from when the form is closed. We have a few form timers that run code every 2 to 5 minutes and the same thing happens, memory usage goes up when the timer triggers but when the code finishes the memory is not released.
I have run CHECKDB on the SQL Express tables, I have also run a SQL Shrink Database. On the front end, I have decompiled the database, run a compact and repair and then recompiled it.
I have been able to reproduce the issue on a computer at my house with a different access database. This database is a 64-bit database with access tables not SQL. The same thing happens, when I open forms then close them the memory usage does not return to the amount before the form was open, always just a little higher until I get the error message.
Microsoft 365 and Office | Access | For business | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
{count} votes
46 answers
Sort by: Most helpful
-
Anonymous
2023-01-09T17:31:01+00:00 -
Anonymous
2023-01-09T17:38:56+00:00 Ok, exactly the same configuration for me.
I'm not sure how we show or give them a way to reproduce. Any ideas?
-
Anonymous
2023-01-09T17:46:47+00:00 My only thought would be to give them remote access to one of our computers so they can see what is happening.
-
Anonymous
2023-01-09T18:07:58+00:00 Hi Mike33511 and SKIRK_70,
My only thought would be to give them remote access to one of our computers so they can see what is happening.
If any of you has a concrete reproduction offer for Microsoft's Access team, you can email me with some information and I will try to put you in touch. You can use my email address from the bottom of this page.
Servus
Karl
-
Anonymous
2023-01-09T18:56:05+00:00 Mike do you have something you can show? I'm working on building something to show specific queries or processes but it's going to take some time.