>I have upsized my database to SQL Server. I created a local database with all my views. Since the database connection uses ODBC, do I have to visit all my users machines to add an ODBC Source? Is there a way to automate this?

You do not need to visit each machine. You do need to verify that the correct ODBC drivers are installed on the client machines. Then you can create a DSN programmatically. You can also verify the installation of the drivers programmatically.

Use my ODBC DSN class to do this. Download it from the files section under the Win32/API category. It is File #9749.