To throw another issue into the mix, we have an Access front-end that connects to several SQL databases via ODBC. One of our databases was running remarkably slow - 40+ seconds to open a form with 2x subforms, all connected to tables in the one database.
The database in question is an MS SQL...