GPO,
One way is read the registry. e.g enumerate the values at :
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI
See
http://www.vb-helper.com/howto_create_dsn.html for examle.
NickHK
"GPO" wrote in message
...
XL 2000
Can anyone point me to a bit of VBA that checks a user's PC for the
existence of a DSN?
Cheers
GPO