CODEWITHSUNDEEP
vbams-access
Fadi
Fadi

Reputation: 3322

How to disable Automatic Calculation in MS Access

I have a query with 4 calculated fields , one of them calculate the running sum using DSum

When running this query and go to the last record it is taking some time (that is normal and OK)

But the problem is that MS Access recalculate this field every time I scroll up or down using mouse wheel, and this recalculation taking a very long time that make this query unusable

I think MS Access do this recalculation because it is multi user application so I change it to Exclusive (File > Options > Client Settings > Advanced > Default open mode > Exclusive) , but this not help

So Im looking for something like Excel to disable automatic calculation and calculate what you need and when you need using VBA for MS Access or at least prevent MS Access from recalculate the query every time I scroll up or down.

Upvotes: 0

Views: 2110

Answers (1)

Andre
Andre

Reputation: 27634

As Nick wrote, you can't.

To view the data without recalculation, put it into a report, or use a INSERT INTO or SELECT INTO action query to save it to a temporary table. The latter is especially useful, if you want to do further calculations on the data, or if it is the recordsource of another query.

Upvotes: 3

Related Questions