How can i test an ODBC connection in VBA code.
I use DAO recordsets.
I know this question is already been raised on this forum, but it's never been answered.
I'd like to write a function like TestConnection = true or false or something
The connection string is like :
"ODBC;DATABASE=namedatabase;DESCRIPTION=x;DSN=x;OPTION=2346;PWD=x;PORT=0;SE RVER=x;UID=x"

Any help would be appreciated alot