Connecting to a DB using ADO

How do Connect to a Access DB via adodc?
I cant remember the syntix...:(

VB Code:

Dim CNN As New ADODB.Connection
    
Dim RST As New ADODB.Recordset
 
CNN.Open GBLSTRCONSTR & STRSUBDBASE5

user-defind type not defind.

Can you please start from the begining, on how can i connect.
I'm new to all this database things...
tnx

PS: My control is ADO Data Control, is that k?

That code eliminates use of bound controls...

You have to adda Reference to get it to work. Ithought you had had some experience in this area before....:confused:

I had very small experience, and what i had, i guess i forgot...:(
I know how to edit, delete, add, and read records.
What i want to do is to read all the records in a table and get it to a listview.
How do i do that? (connecting and read 1 record after another)

K, I guess its too complicated for now.
Well I got this if i use Data Control:

VB Code:

Dim DB As Database
Dim RS As Recordset
Set DB = OpenDatabase(App.Path & "\Stilo.mdb")
Set Data1.Recordset = DB.OpenRecordset("SELECT * FROM Titles WHERE Title Between 'A' And 'B';")
 
How do i continue from now?
I want to read all the records from the table into a listview.

Anyone please?