How to read ODBC entries with VBA

[Tony_VBACoder]

Is it possible to check the ODBC entries using VBA? I
need to add some code in my Initialize routine that checks
the user's ODBC entries for a particular ODBC entry in
their "System DSN" tab.

 

[Douglas J. Steele]

The System DSN entries are stored in the registry under
HKEY_LOCAL_MACHINE\Software\ODBC\odbc.ini

There's code at http://www.mvps.org/access/api/api0015.htm