In my MS Access application, I have several forms that work with data very intensively (several subforms based on even more tables). My users complain that when opening data over the network, the download time is unbearably long.
I have a front end / back slit setting using the excellent autofe app.
One solution that I encountered the problem is instead docmd.close, when the user clicks the "Save and close" me button me.visible = false. Then the user has a long wait time for the first time after downloading the application, but for later loads the performance improves by a noticeable amount.
So far, this has worked quite well. I am simply concerned that there may be hidden, hidden distortions in this strategy that I have not yet encountered.
My users are not too smart, and I do not use the application myself, so I can’t expect to get meaningful feedback if something behaves erratically.
Has anyone else successfully used this strategy or knew that this is not so?
source
share