retriving info from a table using Recordset

Hi everyone, I am trying to access info from a table name
"CUSTOMER DETAILS" using the following code:-

Private Sub LOGINOKBUTTON_Click()
Set dbase = New ADODB.Connection
Set dbasers = New ADODB.Recordset

dbase.CursorLocation = adUseClient
dbase.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=c:\cab\info.mdb"
dbase.Open

If Not dbase.State = adStateOpen Then
MsgBox "Connection Failed"
Exit Sub
End If

dbasers = dbase.O
End Sub

can anyone help me with a bit of explation...
thanks in advance.

bOB.G

You haven't specified your recordset

s = "Select * from [CUSTOMER DETAILS];"
Set dbasers = New ADODB.Recordset
dbasers.Open s, dbase , adOpenDynamic, adLockOptimistic


S-

sbaxter, thanks for the info...it worked