Symptoms

• Attempting to create the VGER DSN manually results in an error: ODBC System DSN Warning You are logged on with non-Administrative privileges. System DSNs could not be created or modified.
• User installing ODBC has full administrative privileges.
• No option is available to run MS Access as administrator

Cause

Some installations of MS Office block the creation of System DSNs and programs cannot be run as administrator.

Resolution

To work around this Microsoft issue, run odbcad32.exe as administrator manually. Then continue with adding DSN before returning to MS Access to link tables: 

1. Click Start.
2. In "Search programs and files" enter "odbcad32.exe"
3. Right click "obdcad32.exe" and select "Run as administrator"
4. Continue the procedure to add the VGER DSN manually as outlined in: VGER missing as a DSN when linking tables 

Article last edited: 18-Jan-2018