If you utilize SQL Server linked tables in your mdb, the attached will automatically create the ODBC DSN when the user opens your mdb. Just put the code in your startup form and it provided the user has permissions to create an ODBC DSN, it will do it automatically.

No need to go to everyone's computer and create an ODBC DSN on each computer.

I use this religiously.