I have an Access front end that uses ms sql as a back end. I am linking the tables with ODBC. For me to deploy this to the field I would have to create a DSN on every machine. WHich I rather not do. Is there a way to use a dsn-less connection within Access. Or, can perhaps a way to have a batch file ceate the DSN on a per machine basis.
I wanted to go with a web format (like everything else I have done) but these folks are so used to access that they cannot seem to part with it....I'm weening them off it slowly
I don't think you can link tables without the DSN, when you want to link to Dbs other than Access.
Now, a DSN is an entry in the registry, namely, in the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI key. One way to do it would be to create the DSN in a computer and then export the key to a .reg file, that you could use to create the key in other computers. I haven't tested this, but I guess it could work.
Topic Locked
Posted - 14 February 2003 : 09:28:50
