Hi There
I want to open access from VB6 and join the tables of my database from VB6 and store the value in an array.
THis is what i have done till now. but i can't make the query from VB6 with SQL.
I don't know what is the problem with my code.

Private Sub Command1_Click()
Dim Conn As ADODB.Connection
Dim cmdd As New ADODB.Command
Dim RecordSet As ADODB.RecordSet
Dim sqlRec As String
Set Conn = New Connection
Set RecordSet = New RecordSet
Conn.Open "provider=microsoft.jet.oledb.4.0;data source=E:\ADOBE\db1.mdb;"
sqlRec = "select students.FirstName,value.value from students"
sqlRec = sqlRec & " inner join value "
sqlRec = sqlRec & "on students.StudentId=value.StudentId;"
recordset.open sqlrec,conn
End Sub


Specify in which line error occurs.
I guess it from your SQL query. Check whether the fields are existing and spelled correctly.