Opening a table causes query? to run?

[gbelanger]

I have a table, that opens very slowly. As it does, the status bar indicates "Running Query". Why would Access run a query when I open a table?

 

[dkinley]

Just a guess ....

Do you have a field that is a look-up field?

-dK

 

[gbelanger]

No, I thought that may be it so I checked each field.

 

[JohnLee]

Hi,

If your table has a large amount of data in it, and you have for instance one or a number of indexed fields, then access treats this like a query and opens up your table having sorted it according to your indexed fields.

Having said that, even if you have no fields indexed, if there is a large amount of data in your table the same thing is likely to happen. It's just the way access works.

John

 

[Pat Hartman]

If Access didn't run a query, how would it retrieve the data? Tables are not text files. The only way to retrieve data from a table, any table, any relational database, is by running a query.

As to the slowness - is the table linked? Have you compacted the database recently?

 

[Micheal Mathews]

If someone has opened the table and sorted or filtered and then saved it, Access will repeat that query each time the table is opened. Right click on the table and choose "Remove Filter Sort" then save the table again.