> I need help setting up a Read connection to a MS Access table. The
> Access file is not located on the same machine that many of the SQL
> servers reside.
>
> Everything works great on the local machine using the ODBC Drivers
> Provider as a one of the rds. The DSN file on the local development
> machine points to the proper MS Access file. When the report is
> deployed to the reporting server (not the local dev. box) a
> credentials error is encountered. Yes, I have a DSN file on both
> different machines with the same name. Any help would be much
> appreciated.
>