Connecting to a DB using ADO

[Stiletto]

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

[James Stanich]

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

[Stiletto]

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?

[James Stanich]

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....

[Stiletto]

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)

[Stiletto]

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

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.

[Stiletto]

Anyone please?