I've inherited an access database that has a SQL Server back end. When looking at the Linked Table Manager, it shows, after the table name, (DSN = LAAT; Database = LAAT). The table data is available even though there is no LAAT datasource on the workstation.
Today we copied the tables for the LAAT to a new SQL Server. However, no matter what I've tried, I cannot view the data in the new database unless I add a datasource connection to the workstation We have users across the company in multiple locations, and setting up the ODBC datasource on each workstation would be time consuming which I assume is why this type of connection was selected initially. Does anyone know how I can view the new table's data without visiting every workstaton to set up a new datasorce?