Database Out Of Memory ON OPENING

[Jaye7]

In the database that I use at work sometimes when we OPEN it we get an immediate error saying out of memory, therefore we close it and reopen and all is good.
This is a problem when the average user logs on as they don't close it, they just continue on and then start experiencing issues.
I thought that the memory was supposed to clear when you close the database.
We run the debugger and no errors are ever found, we also run the compact and repair.
This can happen 1 in 10 or maybe 20 times when we open the database.
Does anyone else experience this and if so have you found a solution.

 

[gemma-the-husky]

possibly indicates a corrupted form, or corrupted dbs.

are multiple users all sharing the same network copy of the database by any chance

 

[Libre]

Do you have an autoexec macro or any other procedure running when you open the db? If so, look at them. An out of memory error sounds like an infinite loop could be running or a calculated field in a query is trying to calculate.

 

[Jaye7]

It happens to various databases, however the one I regularly see it happen on is my own testing database as I am using it constantly so I am the only one using it, there is no autoexec macro running on open, however when the main form opens it does load the custom ribbons etc... I can't see it being the form as it only happens 1 in 10 or 20 times, but it still could be though.

 

[Libre]

Another thought is that, maybe the server where the db is located (including your own local drive) actually IS having memory issues due to network traffic or some other background task is running.

 

[Jaye7]

Thanks for your suggestions