Creating a database connection and recordset

[Pragati]

Hi !

I have an SQL query which im developing on the click of a command
button on a form.

but am stuck up in creating a recordset of that query.
how should one connect to database? use adodb or dao connection? are
there any particular setting reqd in vb editor?
what will be the syntax for connecting to a databse?
what shud be the syntax for opening my query in a recordset?

if i say
dim db as dao.database
dim rs as adodb.recordset
or
dim db as adodb.database
dim rs as adodb.recordset
i get an error message saying "object not defined" ???

also ... can i pass a recordset variable to another form or report?
can a recordset created in one form be accessed in some other
form/report?

please help. this is kind a urgent... !
thanks in advance
pragati

[Steve Jorgensen]

If you use a DAO database object, you need to use a DAO Recordset. If you
want to use an ADO Recordset, you must use an ADO Connection. ADO does not
have a "Database" object.

On 29 Dec 2003 00:58:43 -0800, pr**********@yahoo.com (Pragati) wrote:

Hi !

I have an SQL query which im developing on the click of a command
button on a form.

but am stuck up in creating a recordset of that query.
how should one connect to database? use adodb or dao connection? are
there any particular setting reqd in vb editor?
what will be the syntax for connecting to a databse?
what shud be the syntax for opening my query in a recordset?

if i say
dim db as dao.database
dim rs as adodb.recordset
or
dim db as adodb.database
dim rs as adodb.recordset
i get an error message saying "object not defined" ???

also ... can i pass a recordset variable to another form or report?
can a recordset created in one form be accessed in some other
form/report?

please help. this is kind a urgent... !
thanks in advance
pragati