Using DAO

[yalamanchili]

I need to create a database object and a recordset object in my non vb application to be able to open the database(access) using DAO. I would like to mimic the following vb code in my nonvb app.

public db as database
public rs as recordset

since my non-vb app doesn't know these types, I need to create object and access thru those.
I thought createobject("DAO.database") or createObject("data") would work. but, I am getting error.

Any help would be greatly appreciated.

thanks,vijaya

[jim]

In VB --- in order to use the DAO objects, you must include a reference to the DAO Library in the Project References Section.

As of DAO 3.0, this library has been turned into an OLE type library that can be used with OLE/COM applications. Specifically C++ applications.

Check out the dbDAO classes.