Solved

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

Posted on 2014-12-13
4
502 Views
Last Modified: 2014-12-15
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
Comment
Question by:David Smithstein
  • 2
4 Comments
 

Author Comment

by:David Smithstein
ID: 40498077
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
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40499213
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
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 40500048
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
 

Author Closing Comment

by:David Smithstein
ID: 40500474
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now