MS Access 2013 - constantly calculating

Question

_{Wednesday, October 15, 2014 6:02 AM}

Hi,

I'm using Access 2013 at work. The database in question was recently updated from a 2003 version and has been working flawlessly for a few weeks over a network and on a Win 8.1 box. This morning on starting it, I noticed that the status bar was displaying "Calculating..." and all of the calculated fields in the main form are blank and refuse to populate until i press the F9 key. Then everything calculates correctly, but the status bar still shows "calculating". If, after pressing F9, I go about my work - switching between the tabs, entering data etc, at some point all the calculated fields will again go blank, F9 and they all come good again. I have 7 tabs on the main form, all with sub forms attached and the main form and 3 or 4 of the sub forms have calculated fields.

As I said, this database has been operating flawlessly up to this point and still does everything it should except for the Calculations...

Any ideas?

thanks for your help.

All replies (5)

_{Friday, October 17, 2014 6:27 AM ✅Answered}

Hi,

Have you gone the update history to check if installed some Office patches recently? If there have, I recommend try to remove them one by one to test.

Then, sometimes, running different versions of Office products on the same machine - for example, are you running Word 2010 and Access 2013 on the same machine, at the same time? This might cause issues as well.

Next, I recommend we make a clean boot for your computer before you run Access 2013 to test.

For the detailed steps, please refer to the below link:

http://support.microsoft.com/kb/331796/en-us

And, we also could try to repair Access.

http://office.microsoft.com/en-gb/word-help/repair-office-programs-HA010357402.aspx

Regards,

George Zhao
TechNet Community Support

It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.

_{Thursday, October 16, 2014 6:30 AM}

Hi,

In regarding of the issue, it might be caused by some reasons. Have you converted the MDB format to ACCDB format?

Then please follow the steps and check they are helpful.

First, if the forms use Conditional Formatting, it might be caused the issue. Please try to remove them.

Second, if there are some events in forms continuously running, it also might be caused the issue. Please check them.

• Check all the open forms in your app by going into the Immediate window and doing a forms.Count
• Check EACH of those open forms (forms(0).Name, Forms(1).Name, etc) to make sure there is no Form_Current or Form_Timer event continuously running

Third, the issue also caused by a number of calculated controls, these where replaced with bound countrols. The calculating message now only appears for under a second when switching tabs or after leaving a field that has had some data changes.

Forth, if you have install some third-party add-ins/programs, we'd better disable/remove them to test.

Fifth, if the issue still exists, please try to compact and repair a database.

https://support.office.com/en-us/article/Help-prevent-and-correct-database-file-problems-by-using-Compact-and-Repair-6ee60f16-aed0-40ac-bf22-85fa9f4005b2

Regards,

George Zhao
TechNet Community Support

It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.

_{Thursday, October 16, 2014 7:15 AM}

Hello George,

Thanks for your reply. I will try to answer your points:

1    No conditional formatting anywhere in any form

2    No events running in any form - events/actions only occur when a form button is clicked to complete an action - run a macro or piece of code etc

            I have one main form with 8 sub forms each in it's own tab.

            There are no Form Current or Form Timer events running

3    Some of the forms have quite a number of calculated controls, however they were not causing any issues prior to yesterday. As I said, the database has been running flawlessly for a number of weeks since it was converted to .accdb format. SO this cannot be the problem else it would have been occurring since the conversion was done.

4    No 3rd party add-ins installed

5    Compact and repair already performed a number of times to no effect.

I have also used the analyze performance function and corrected any issues it detected but it is still not fixed.

Today I opened some other databases and they all exhibit the same problem. This along with the fact that it just started to happen to my previously fine database, suggests that it is s MS Access issue and not related to the my database file, it's format or it's content. Perhaps it is related to some update that occurred overnight?

thanks for your help

Jordy

_{Tuesday, May 29, 2018 5:44 PM}

I was having this happen with Access 2007. Eventually I found in Task Manager there were multiple instances of MSACCESS.EXE running. But I had closed all Access windows; these were copies stuck running in the background. I killed them all, reopened my database, and the "Calculating..." problem went away.

_{Wednesday, December 11, 2019 7:54 PM}

I had the same problem, with Access 2013 64-bit.  It occurred on a very simple form (three text boxes and a command button).  No background instance was running.  The problem went away after rebooting.