Hi All!

i got the the following error while on open the recordset.
plx explain.
Microsoft JET Database Engine (0x80040E14)Syntax error in FROM clause.

it's my source code :
<%@ Language="VBScript" %>

<%
'declare the variables
Dim cn , rs
Dim sSQL, sConnStr

'declare SQL statement
sSQL="SELECT * FROM [User]"

sConnStr="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("Login.mdb")


'create an ADO connection and recordset
Set cn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")

'Open the connection to the database
cn.Open sConnString

'Open the recordset object, execute the SQL statement
rs.Open sSQL,cn,3,1,2
%>



Muthu

__________________
Muthu

try changing your sql to:
sSQL="SELECT * FROM User"


----------------------------------------------------------
I hear that the song "Hot Shot City" is particularly good.
----------------------------------------------------------

Hi,
   I think "User" is a key word. Change the name of the table to some other name and try again.
Thanks
Suresh

User is indeed a key word. Also avoid the common mistake of having a field called password. It is also a keyword.

I don't think that should be a problem. Though it is advisable to avoid keywords while creating columns names etc., ... in some unavoidable!!! situations if we create it we can use it within a square bracket. Say, [Name]

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

btw I forgot to say that I have used it only in SQL Analyser .. and I am not too sure whether my statement holds good for ASP pages also.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com