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!