Solved

Microsoft Access forms "Calculating..."

Posted on 2015-02-24
1
137 Views
Last Modified: 2015-08-20
Hello,

I have a new machine running Access 2013.  I moved a current project from a 2010 machine and first noticed that if I run a make table query, after it runs, I need to hit F5 in the database window for the table to appear.  I am also noticing that forms display Calculating... in the bottom of the form and refresh EXTREMELY slowly.  I saw some info on conditional formatting and I even went so far as removing all subforms from the current form.  No difference.

Also the same on any form.
0
Comment
Question by:vmccune
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 40629309
You might need to perform some maintenance on your db. First make a backup, then do this:

1. Compact the database
2. Compile the database. Fix any issues you find, and keep doing this until the menuitem is disabled
3. Compact again.

Now Decompile the database. To do that, create a Shortcut with this as the Target:

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

Run that shortcut, then do the 3 steps above again.

You might also consider moving everything into a new, blank database, especially since you're moving from 2010 to 2013. Quite a few users have reported similar issues when doing the same, and moving to a new database helped.

Also be sure your Windows and Office installations are fully up to date.
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

732 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