server filter is missing
using access with any data source / linked tables is very problematic when we deal with large number of records!!!
currently query data from table with filter bring all table to memory then filter, the result is very poor performance and bloated network traffic
while thinking of sql server connectors learn from what was working and you "killed"
bring back the ADP server filter
this concept get only the subset of records related to the "server filter" from server
we don't need all functionality of ADP!
we need the connectivity and the featured such as:
one connection for all tables / views / functions and stored procedures
these are very critical for LOB application
bring them back!!!!!