I'm wondering if/how an SQL Server would be impacted by an Access DB that has ODBC Read-Only linked tables from that SQL Server on it.
If a form event triggers a query on one of those linked tables, is that query hitting a local version of that linked table, or is it going to impact the overall performance of the SQL Server? I have about 30 users simultaneously using an Access Front End, linked to an Access Back End, and have added functionality that draws on several of our SQL Server's tables; I just can't allow that many users to be hitting the server with query on top of query. It would bog down the SQL Server immensely.
If you have any ideas on how to best proceed, let me know!