I have an application I have created. It uses a SQL SERVER database
and a MS ACCESS front end. I have a ODBC connection to the database. This has worked fine for design and production. I am now ready to test my application out on a "user machine" and do not have the ODBC connection. I know how to manually go into the control panel and set up a connection. My question is, is there a way to do this automatically? or is there a way to set up the connection in the application so that the machine it runs on is not dependant on having the dsn entry?


thanks.