What I think I need to do is create an ODBC connection between a computer that has the Access file and the computer running the SQL Server.

While I have never used SQL Server Reporting Services, it seems to have a lot of advantages over an Access-based reporting tool.

Please note that Integrated Security=false was set in the connection string used above, as the example uses SQL Server Authentication. If Windows Authentication is used, this must be adapted.

Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...