Go directly to the back-end database to optimize query processing. Bill Pearson leads a hands-on introduction to implementing Pass-Through queries to MSSQL Server 2000 from an MS Access client.
This story continues at http://databasejournal.com/features/...le.php/3347631
