Link to home
Start Free TrialLog in
Avatar of David Smithstein
David SmithsteinFlag for United States of America

asked on

MS Access Screens set to Continuous forms slow to refresh after Windows update

So I started working on my Access App this morning and all of a sudden I'm getting these long hang times on my screens set to Continuous forms.   The screen is only attempting to display one record via ODBC link to a MySQL database running on the same machine (Localhost)

I suspect it's Windows update related, as I've read a little about some recent drama with Microsoft Updates.  I put in messages at the beginning and end of the On Load and On Open code and both run quickly between the "start" and "end" messages.  However,  after the last message the shell of the screen is visible, but the contents don't repaint/fill in for a good 20+ seconds for something that was happening instantaneously only yesterday.

I've checked other screens that were running fast yesterday, and they all seem to be having this issue.

Is anyone else experiencing something similar or know what's going on?

Thanks!
Avatar of David Smithstein
David Smithstein
Flag of United States of America image

ASKER

Now the problem seems to have been resolved.  A while back I was losing these settings:
 
DoCmd.SetWarnings False      ' disables messages about update queries

            Application.SetOption "Confirm Record Changes", False
            Application.SetOption "Confirm Document Deletions", False
            Application.SetOption "Confirm Action Queries", False

So I had duplicated this code in a few strategic places to reset them.  I noticed a button that opened my Continuous Form screen normally and found this code was the primary difference.  Why it was causing a long hang time all of a sudden is anyone's guess, but going back to making this setting one time at login seems to have resolved the hang time behavior.
Avatar of Phillip Burton
Phillip Burton

I would not suggest keeping DoCmd.SetWarnings False on permenantly.

If you have a query open, and close it, expecting it to ask you "Do you want to save it?", it won't! Just one of the issues with it set to False.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi Scott, been using the /Decompile thing for a while now, and I believe you are probably right about this being the root cause. - Thanks.