Member Avatar for Afi83

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
  • 2 Contributors
  • 1 Reply
  • 98 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by selvaganapathy
Member Avatar for selvaganapathy

Hi,

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.