I have a large SQL Server table (9 million rows) linked to Access. This table is used in a subform. I can filter this subform and the response is very good assuming I have indexed it on SQL Server. When I click to remove the filter the screen hangs for a while. Sometimes I have to kill Access. I do not know why this is happening.
Also when I remove a filter from one subform it removes the filter from another subform on the same master form.
Thanks in advance