Slow Loading of Forms

[RichD]

I have seen this question before, but didn't need the answer till now. I have searched FAQ and Keyword Search, without success, so here's the question;

I have an application in Access2000 in which several forms take a long time (about 30sec) to load, after that they load quickly (presumably they are in cache). I have compiled the VBA code and compacted the mdb, it does not make any difference.

Any help greatly appreciated.

Rich Lead Developer

http://www.blsoftware.co.uk

 

[psemianonymous]

This is kind of cheap help, but the newsgroups have a bunch of (semi-unhelpful) threads on slow form loads:

http://groups.google.com/groups?hl=...low+form"&meta=group=comp.databases.ms-access

One suggestion I liked that actually looked helpful is to keep your forms open even when they are "closed". Thus when they are re-opened, the time penalty is eliminated. You can even open all troublesome forms on startup (hidden) and "open" them quickly after the initial startup delay.

Most of the other threads said "design your databases better". One amusing thread said to upgrade to a whopping 12MBs of RAM, if you can justify the cost. This is the thread where he suggested you "hide" the forms instead of closing them:

http://groups.google.com/groups?hl=...ess&hl=en&lr=&ie=UTF-8&oe=UTF-8&start=10&sa=N

I'm having far too much fun with this. --
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access