Open Table - Calculating

[T2B]

When you open an Access table and there is a message in the lower left
hand corner "Calculating..." What is it calculating? In the table I'm
looking at I don't see any fields that have default values or values
dependent on other columns, etc.

 

[Clifford Bass]

Hi,

It just means that it is working/doing something and the results are
not yet all available. Technically, it is accurate since any operation
involves calculations. Although when the message goes away, Access is still
"calculating" all kinds of other stuff. From a user's perspective, something
like "Working..." or "Querying..." or "Processing..." might be more
meaningful.

Clifford Bass

 

[Bob Quintal]

m:

When you open an Access table and there is a message in the lower
left hand corner "Calculating..." What is it calculating? In the
table I'm looking at I don't see any fields that have default
values or values dependent on other columns, etc.

It may be calculating the order to display the records, because you
have set and saved a sort order in the table, but do not have an index
on that field. You can see the sort order by looking at the table
properties from design view.

 

[kate]

m:


It may be calculating the order to display the records, because you
have set and saved a sort order in the table, but do not have an index
on that field. You can see the sort order by looking at the table
properties from design view.