Automatically create DSN in MS Access

Hi

I know this has been covered many times, but reading through all the threads has just made me even more confused!

I am hoping someone can provide me with some code that will automatically create a DSN when you open Access (2002, 2003 and 2007). I have to use DSN so cannot go down the DSN-Less route (not that I made much sense of that either)

The connection to the SQL Server is not a trusted connection.

I don't know what else to tell you about the database that would help, but I just ask.

I just don't fancy creating (or trying to talk the user through the proccess) a DSN on over 300 machines.

Any help would be greatly appreciated!