Access forms freezing

Posted on 2014-08-13
Medium Priority
Last Modified: 2016-02-11
Hey Everyone,

I have a form freezing problem with my Access 2010 program.  The program has one main form that has an area where many different subforms could appear.  At seemingly random times, with different subforms trying to appear (so it is not just with one or another), the screen does something funky and the person using it has to shut down Access.

I have attached a picture of what it looks like, but basically you can see the main form BEHIND something that is trying to appear.  Sometimes that something is even the behind the scenes of Access. The subform area is under the line of buttons you see.

Here are some specifics that may be relevant:
1. The front and back end have not been split
2. Everyone accesses the same version via a shortcut on their desktop to where the program resides on a server
3. Even though there can be as many as 6-12 people on it at once, the issues above happen even if there are one or two on the system.

Any insights would be VERY helpful.
Question by:alevin16
  • 3
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 40259546
I would suspect corruption. While you can fix that in most cases, if you don't fix your architecture, you'll continue to have issues.

By "fix your architecture", I mean that you should split the database into a Backend (Tables only) and a FrontEnd (everything else), and deploy a COPY of the FE to each user's desktop (i.e. they would NOT all share the same FE from that network directory). There are several methods available to copy the FE to the user's machine, so there is simply no reason to do otherwise.

To try and fix the corruption, first make a backup, then do this:

1. Make sure all Machines are fully updated regarding Office and Windows
2. Compact the database
3. Compile the database - from the VBA Editor window, click Debug - Compile. Fix any errors, and continue doing this until the menu item is disabled
4. Compact again.

Sometimes you must decompile the database. To do that, create a new Shortcut with a Target like this:

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

Run that shortcut, then run steps 2, 3 and 4 again.

You might also consider moving everything over to a new, blank database. To do that, create the new database and then use the builtin Access methods to move over all your objects.

Note too that it's possible that you have corrupt object (like a Form or Report). If you suspect that, then you'd need to NOT move that object over, and instead recreate it from a recent backup. The only way to really determine that is to go through your objects one by one to see which of them causes the issue. In many cases, a corrupt object will not import to a new container, so you could perhaps determine it that way.

Author Comment

ID: 40259557
Wow this was extremely helpful!  Thank you!  I am going to try this, I never knew about the decompile, that is definitely worth a shot (as well as the splitting)
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40259812
Just FYI,

To get better screenshots:
Hit the PrtScr button on your keyboard
Open MS Paint
Click edit-->Paste
Then save the file and post the file here using the "Insert Image" button:
Like this:
Sample screenshot


Author Comment

ID: 40261114
Thank you!  I appreciate any tips and tricks :D

Author Closing Comment

ID: 40624543
We split it and all went well!

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

I came across an unsolved Outlook issue and here is my solution.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

612 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