D
dbuschmohle
Hello,
I am using the datasheet form in Access 2007 to display roughly 12,000
records data from SQL... This is then used as the inventory view for our
sales team. When moving to Office 2007, I was told that the new datasheet
filtering capabilities were comparable to Excel... After implementing the
Access application though, I’ve found that just getting the drop down filter
to appear takes almost 5 seconds... So although the functionality is similar
to Excel, the speed definitely is not. Someone told me this is because it is
pulling live data from SQL and to try the following:
"Try copying the record data locally before opening the filter dropdown. If
you do this (by using a disconnected recordset, or by caching to local
tables) and bind to the local data"
Can anyone give me an idea on how to do this...? Also, any other thoughts
and/or input on datasheet filtering in general would be appreciated.
Thanks,
-Dave
I am using the datasheet form in Access 2007 to display roughly 12,000
records data from SQL... This is then used as the inventory view for our
sales team. When moving to Office 2007, I was told that the new datasheet
filtering capabilities were comparable to Excel... After implementing the
Access application though, I’ve found that just getting the drop down filter
to appear takes almost 5 seconds... So although the functionality is similar
to Excel, the speed definitely is not. Someone told me this is because it is
pulling live data from SQL and to try the following:
"Try copying the record data locally before opening the filter dropdown. If
you do this (by using a disconnected recordset, or by caching to local
tables) and bind to the local data"
Can anyone give me an idea on how to do this...? Also, any other thoughts
and/or input on datasheet filtering in general would be appreciated.
Thanks,
-Dave