>1. In GetRecordSet - DataAccessAPI module when a sql statement is passed oRecordSet.Open gives an error. However on testing it is further determined that

I downloaded the sample again and took a look at it. It works fine on my machine, including the executable that came with the package. Make sure you have the right version of ADO installed. I suspect that is the problem.

>2. Could someone explain the Err.Raise lErrNo, OBJECT, sErrDesc statement in the above function! I beleive it is faulty!

That statement appears correct. That statement reraises an error that occurs earlier in the procedure (if there is an error). The OBJECT name is a constant they defined at the top of the module. They reraise the error because their error handler closes the data connection first.

Best,

jody