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