• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 618
  • Last Modified:

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!
0
David Smithstein
Asked:
David Smithstein
  • 2
1 Solution
 
David SmithsteinCEOAuthor Commented:
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.
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
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.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Does this happen on other databases as well? If so, then I'd suggest you insure your Office/Access installs are fully up to date as well.

If not, then my might have a corrupt database. Create a backup, then do this:

1. Compact the database
2. Compile it - from the VBA Editor click debug - Compile. Fix any errors, and keep doing this until the menu item is disabled.
3. Compact again

Try to Decompile the database. To do this, create a Shortcut with a Target like this:

"full path to msaccess.exe" "full path to your db" /decompile

Run that shortcut, then do the 3 steps again.

Finally, you might consider moving everything to a new, blank database.
0
 
David SmithsteinCEOAuthor Commented:
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.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now