A colleague who has an MS access application that connects via ODBC to an Oracle database, recently had their laptop upgraded to Windows 7.
The company sys admin logged on remotely, installed an Oracle Client and set up a System DSN. In the ODBC configuration dialog box, the support guy clicked on the Test Connection, entered the credentials and got “Test Successful”.
How can this DSN be made available to my non-admin colleague and the MS access application that needs it?
