Hello MS Access Expert,
Suppose I have a table Y with 30K records and I have two queries in MS Access which are identical (SQL = Select x from Y where x = "a").
When I open the first query the results appear instantly. While keeping the first query open, I subsequently open a second identical query and the same results now take 15 seconds to open. Why is MS access behaving this way when the two queries are identical?
I also noticed that if the first query is opened and then table Y is opened subsequently it is also very slow, hence, this is not isolated to queries.
I would like to first understand why MS Access behaves like this and then I can produce a workaround.
Thank you.
Suppose I have a table Y with 30K records and I have two queries in MS Access which are identical (SQL = Select x from Y where x = "a").
When I open the first query the results appear instantly. While keeping the first query open, I subsequently open a second identical query and the same results now take 15 seconds to open. Why is MS access behaving this way when the two queries are identical?
I also noticed that if the first query is opened and then table Y is opened subsequently it is also very slow, hence, this is not isolated to queries.
I would like to first understand why MS Access behaves like this and then I can produce a workaround.
Thank you.