To perform this operation, the Microsoft Jet database engine searches the specified table or tables, extracts the chosen columns, selects rows that meet the criterion, and sorts or groups the ...

Processing is carried out by SQL Server on the database server, not in Access on the client side. As a result, you’ll see a reduction in network traffic (as opposed to a split MDB).

Find how-to content, sample code, SDK and API documentation, VBA references, training, and articles for developing solutions and customizing Office. To merge a PR, please @lindalu-MSFT in comments ...