Access application size increases continuously while only doing an OnTimer
Posted on 2014-01-23
I have an Access app in which I wanted to add the storage of a heart beat when it is running. So I added a form timer on the main form, and on the timer event (every 5 seconds currently), I store in a small table under the name of the application the current date an time, so that other apps can find out if that app is running. I have used that technique a number of times in the past and never had problems.
But this time, the app grows by 12 KB everytime the time event is processed ! I have checked my table update , I close the table and set the recordset variable to Nothing, so it doesn't look like there could be some garbage created and not collected.
Any idea what it could be ?
Thanks for suggestions.