We have developed several applications using MS Access/VBA that connect to our Oracle 8i database. On each PC that uses these applications I create a System DSN configured using the Oracle ODBC drivers. The PCs have operating systems that go fromWindows 95 to Windows XP.
Currently, I must add the appropriate drivers and configured DSN to each new PC. Then every couple years I end up updating all PCs because of compatibility of the Oracle ODBC drivers and the database/Oracle client software versions. This seems very inefficient and I am wondering if there is a better way to do this. Is it possible to place the definition of the DSN and the appropriate drivers out on the network and then somehow configure the client DSN to point tothese things? What is a file DSN? Would it be something I could use for this function?