I need to distribute an access front end, using MySQL (or Sql Server perhaps) as a back end. How can I automate the process of establishing the DSN connection on each user machine (more than 300 spread over multiple parts of the a huge company with different networks). It appears I need to go to Adminstrative tools etc and actually enter a userid/password for the user.
Anyone have specific expertise with distributing Access Front end across many users without having to go and configure each user workstation (I understand we're stuck with installing the ODBC driver).
(I can use either MySQL or SQL Server as the back end - If SQl Server, I must rent a virtual machine and install/configure myself - MYSQL already configured and running).