What"s wrong with this??

Does anyone see what would be causing the error below? This should be so
simple! I'm not seeing what the problem is.

The connection string is fine, the db, tables, and fields are identified
correctly so I don't get it!

Dim strEmail, strPassword, strSQL
strEmail = Request("Email")
strPassword = Request("Password")

Dim rsUsers
strSQL = "SELECT * FROM user WHERE userEmail = '" & strEmail & "';"
Set rsUsers = Server.CreateObject("ADODB.Recordset")
rsUsers.Open strSQL, objConn



Microsoft JET Database Engine error '80040e14'

Syntax error in FROM clause.

Thanks!
John

Re: What"s wrong with this??

"John" wrote in message
news:b9WLd.25994$ZD1.13545@twister.nyroc.rr.com...
> Does anyone see what would be causing the error below? This should be so
> simple! I'm not seeing what the problem is.
>
> The connection string is fine, the db, tables, and fields are identified
> correctly so I don't get it!
>
> Dim strEmail, strPassword, strSQL
> strEmail = Request("Email")
> strPassword = Request("Password")
>
> Dim rsUsers
> strSQL = "SELECT * FROM user WHERE userEmail = '" & strEmail & "';"
> Set rsUsers = Server.CreateObject("ADODB.Recordset")
> rsUsers.Open strSQL, objConn
>
>
>
> Microsoft JET Database Engine error '80040e14'
>
> Syntax error in FROM clause.
>
> Thanks!
> John
>
>
http://aspfaq.com/show.asp?id=2080

Re: What"s wrong with this??

oh man....why is it always the dumb things that drive you the most nuts????

Reserved word, that was it, thanks!

"Chris Hohmann" wrote in message
news:e7snfkMCFHA.1404@TK2MSFTNGP11.phx.gbl...
>
> "John" wrote in message
> news:b9WLd.25994$ZD1.13545@twister.nyroc.rr.com...
> > Does anyone see what would be causing the error below? This should be
so
> > simple! I'm not seeing what the problem is.
> >
> > The connection string is fine, the db, tables, and fields are identified
> > correctly so I don't get it!
> >
> > Dim strEmail, strPassword, strSQL
> > strEmail = Request("Email")
> > strPassword = Request("Password")
> >
> > Dim rsUsers
> > strSQL = "SELECT * FROM user WHERE userEmail = '" & strEmail & "';"
> > Set rsUsers = Server.CreateObject("ADODB.Recordset")
> > rsUsers.Open strSQL, objConn
> >
> >
> >
> > Microsoft JET Database Engine error '80040e14'
> >
> > Syntax error in FROM clause.
> >
> > Thanks!
> > John
> >
> >
> http://aspfaq.com/show.asp?id=2080
>
>