I have an MDB on a network share that I want many users to access. It contains reports based on SQL Server data from linked tables. I get it to run on my machine using the file DSNs in the same network folder as the mdb, but when another user opens the database and tries a report, there is an ODBC error. I don't seem to be able to tell Access to look for DSN files. Is there a way to get this working without going to each desktop and installing something?

Thanks,
Cheryl