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

ACCESS 2010 SP2 / problem with recalc

I have a problem with the Recalc on a form.subform. fieds
It seems to have appeared with the SP2 update of Microsoft Office.
it's not a software programing problem
The update of calculated fields does not work automatically – if we use a button with Basic instruction form.recalc, the field is calculated. Otherwise it is empty
We have verified the system parameter for the access Buffer jet4.0, and it is the same than other customer’s servers

We don’t have this problem on another similar customer’s servers
Verified of the software version and so on
See attach file with version of MsAccess and Windows server R2 Standard X64
  • 3
1 Solution
patrickgermainAuthor Commented:
Sorry, Ii have forgotten to say Thanks for answer
Calling from France - kind regards
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Looks like SP2 only affects the Access Runtime:


You also mention a server - how are you using Access on the server? Are you running a RDP environment, or does the server simply host the Access database?

If you're running an RDP, and if this happens on that machine only, then the trouble is apparently with the installation of Windows/Office on that machine. I'd first try a Repair of Office (or just Access). If this happens only on certain RDPs, you might try recreating those RDPs, or doing a repair/reinstall of Office on those.

If you're NOT running an RDP server, then you'll need to give more details about the environment.
patrickgermainAuthor Commented:
We are running RDP
I will repair Access.
A bientôt - bonne journée
patrickgermainAuthor Commented:
Many thanks - repair was the solution.
Bonne journée
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:

\It is not real obvious but is you read done the list of updated products you will see:

Office 2010 SP2 (includes enhancements to Access, Excel, Outlook, and Word)

There is a separate SP2 package just for the Access runtime that does not includes the updates for all the other office apps. That really helps reduce the package size.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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