Enter your question or search term
eg. 'what are my email server settings'
DSN & DSN-less connections
Here are examples of both DSN and DSN-less connections taken from:
http://support.microsoft.com/kb/193332
DSN
' Access ODBC Driver via DSN
con1.Open "PROVIDER=MSDASQL;" & _
"DSN=OLE_DB_NWind_Jet;" & _
"UID=admin;PWD=;"
DSN-less
' Access ODBC Driver via DSN-Less
con1.Open "PROVIDER=MSDASQL;" & _
"DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ=C:...NWind.mdb;" & _
"UID=admin;PWD=;"
