Fredd
asked on
Setting up DSN/ODBC connection on user machines
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).
Thanks
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).
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for Keyboard Cowboy's comment #a40680419
for the following reason:
none
Accepted answer: 0 points for Keyboard Cowboy's comment #a40680419
for the following reason:
none
I think you accepted the wrong solution.
ASKER
Does this avoid users having to cI figure via administrative tools. New at this. Thanks.