system error (missing operator) in query expression

[LEAN.HEART.YOU]

  Sub all()
        connection()
        Dim see = "Select * from info where Last Name = '" & txtLast.Text & "' and First Name = '" & txtFirst.Text & "'"
        dcom = New OleDbCommand(see, dcon)
        dcom.ExecuteScalar()

        If dcom.ExecuteScalar > 0 Then
            Dim gather = "Select * from info where Last Name = '" & txtLast.Text & "' and First Name = '" & txtFirst.Text & "'"
            dcom = New OleDbCommand(gather, dcon)
            dr = dcom.ExecuteReader
            dr.Read()

            If dr.HasRows Then

                Dim last = dr(1)
                Dim first = dr(2)

                MsgBox("The name" & last + first & "already exists!")


                dcon.Close()
            End If
        Else
            borrower()


        End If
    End Sub

• Whenever I click the button for saving. it always says "Syntax error (missing operator) in query expression" What will I do? :|

[pritaeas]

Spaces in column names are the problem. If you are on SQL Server put them in brackets.

[LEAN.HEART.YOU]

What do you mean by that? I'm only connecting it to MS Access. Can you explain further more. Sorry I'm just a newbie here. :)

[pritaeas]

Select * from info where [Last Name] ...

[LEAN.HEART.YOU]

Even in "and First Name"? Should I put bracket?

[pritaeas]

Yes.

[LEAN.HEART.YOU]

Okay. Thanks man! :D

[Reverend Jim]

To avoid confusion it is better to remove the blanks or replace them with underscores as in LastName or Last_Name

[LEAN.HEART.YOU]

Still the same man. No changes. The same error. Syntax error (missing operator) </3