hi,
i’ve been using sql server 2005 where a placed my databases and as front end i am using Ms access 2007 i have the tables linked..
one of the tables contains 3000 records
when i want to see all records it takes a long time .. but it makes it easier to filter data on the spot as we dont always know what the filter criteria would be upfront.. my database here is in “.accdb” format.
if i switch to .adp format it works much faster .. but the filtering with the autofilter int the colmn headers doesn’t make sense and the totals in the totals row(new feature of ms access 2007) still displays all records count and totals rather than the filterd totals like in the .Accdb format
i would like to see the data load faster and these filters working properly with the totals also working poperly..
how to do this while still keeping frontend in MS Access 2007??