两种数据库打开程序区别

请问兄弟们.以下两种打开数据库程序 有什么区别? 哪一个更好?

                 1--------------------

               dim SQL as string

               dim db as datebase

               dim rec as recordset

               set db = currentDB

        SQL="SELECT * FROM IIIII"        

set db= rec.openrecordset( sql,)

                2--------------------

                dim st  as string

                dim rs  as adodb.recordset

                set rs = new adodb.recordset

          st="select * from iiiii"

               rs.open st

我感觉第二中简洁.请问,两种数据打开方式有什么区别???

谢谢!