I've just converted an entire Access application to run from a SQL Server backend. While I've eliminated the need for local tables by using stored procedures, I've found I still need linked tables to run reports.
The Access database is in a shared folder, and it's tables are only accessible by the client where the linked tables were actually linked. Any other user who trys to open the tables will receive an ODBC call failed error.
How can I link the tables so that they are accessible by all users?