HI!

i am having problems with the libraries (DAO,Adodb)that support recordsets.

when i write sql code and try to assign it to a recordset varaible it doesnt work........

Can anyone let me know which library do i need to select from the 'reference' dialogue box to get me going with recordsets ?

First of all, what code are you trying to use?

Either the DAO or ADO depending on which recordset you want to use. If you are just using MS Access data the DAO recordset would be more efficent. If you have a reference set to both of the library you have to specify the type of recordset.

Dim myRec as DAO.Recordset
Dim myRec as ADO.Recordset