About SQL statement

[Guest_imported]

I have a statement :
"rs.Open ("SELECT * FROM user WHERE [loginname] = '" & txtUserName.Text & "'&quot, cn, adOpenStatic, adLockOptimistic, _
adCmdText"

then it says :
"Syntax Error in FROM clause "

I don't know what's wrong it is
Pls give me some opinion
THX

 

[MarianoMartinez]

user is a reserve word. If that is the table ou must be fully qualified.