Hi all Pro,

Please tell why I face this problem as below:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in FROM clause.
/web/CheckLogin.asp, line 10

Then my coding is as below:
Dim strEMail, strPassword
strEMail = Request("EMail")
strPassword = Request("Password")

Dim rsUsers
set rsUsers = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM User WHERE EMailAddress = '" & strEMail & "';"
rsUsers.Open strSQL, objConn
...

Please help me...this is very urgent to me.

User is a reserved Keyword; try this instead: SELECT * from [user]

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========

How to say it is a reserved keyword???And what does it using for???
I have see another program also write the coding like that,but it can run without error.Then it's reserved keyword is "Person".But I facing that kind of problems...why???

Thank you...

Ok. In most database systems there are reserved keywords, just as there are in programming languages. (string, int, double, float, etc)

SQL is no different. In any event user, at least in SQL Server, is a reserved keyword so you can not directly reference your object. What I mean is that while you can name a table named 'user' you can not reference it such as:

SELECT * from user

because SQL thinks you are trying to do soemthing with the user type so, instead, you need to reference your table with [ ].

No, person is not a reserved keyword.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========

Like that...
Ok, I understand.

Thank you very much