I need to connect my MS Access (front-end) database to SQL Server 2008 (back-end), using my ODBC connection, for all of my team to view the data in the MS Access reports, forms, etc. My MS Access front-end database contains linked tables to a specific database in SQL Server, using an ODBC connection (System DSN - SQL Server Native Client 10.0). Note: My team has read-only access to the database in SQL Server.
The ODBC connection will work on my machine (System DSN, User DSN, and File DSN), but I don’t know what I need to do to configure my teammates' machines so they can connect to my ODBC data source/use my ODBC connection. My teammates do not have Access or SQL Server on their machines; they will be retrieving the Access database through a shared network.
Any help you could provide on how/what I need to do to set up my teammates' machines so they can view the data in the MS Access reports would be greatly appreciated! Please let me know if I need to provide more information in order to solve this problem.