Syntax error (missing operator) in query expression 'Serial Number = 'L3FW341''.

[Dilip Krishnan]

Syntax error (missing operator) in query expression 'Serial Number = 'L3FW341''.

The Serial Number field is declared as text in Access Db.
I am not sure which operator is missing in my command!

Below is my code:

Cmd1 = New OleDbCommand("Select * from Asset Details where Serial Number = 'L3FW341'", Conn)
        Da = New OleDbDataAdapter(Cmd1)
        Db1 = New DataTable()
        Da.Fill(Db1)

[Stewart Ross]

You have spaces in your table and field names. Names with spaces must be enclosed within brackets, like this:

"Select * from [Asset Details] where [Serial Number] = 'L3FW341'"

-Stewart

[Dilip Krishnan]

Thanks Stewart, that worked. :)