I need to open a table whose name has been typed in a form but I get this error :


Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.



This is my script :

dim strexhib
strexhib = request.form("exhibition")

Set Conn=Server.CreateObject("ADODB.Connection")
strConn="driver={Microsoft Access Driver (*.mdb)}; "
strConn=strConn & " DBQ=" & Server.MapPath("exhibitions.mdb")
strConn=strConn & ";pwd=" & strCode
Conn.Open strConn

sql = "SELECT * FROM " & strexhib

Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn ,3,3


Any help really appreciated !!!
Ske

hi,

Did you try with

sql = "SELECT * FROM " & CSTR(strexhib)

Prashant

I tried your piece of code but it still doesn't work. Keeps telling me that there's an error in the FORM line.

Hi ,
  Can u print the content of 'sql' using reponse.write(sql).