select * from...

[brunow 0]

sqlstmt = "SELECT * FROM '" & prof & "' where id='" & id & "' ORDER BY id DESC"O erro que dá é:Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][Driver ODBC para Microsoft Access] Syntax error in query. Incomplete query clause. /paginas/donakelna/prof.asp, line 92

[gastao 0]

sqlstmt = "SELECT * FROM '" & prof & "' where id='" & id & "' ORDER BY id DESC"O erro que dá é:Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][Driver ODBC para Microsoft Access] Syntax error in query. Incomplete query clause. /paginas/donakelna/prof.asp, line 92

id deve ser numerico, entao, "&id&"

[brunow 0]

          sqlstmt = "SELECT * FROM '" & prof & "' WHERE zona="&zona&" ORDER BY id DESC"

continua dando erro:

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][Driver ODBC para Microsoft Access] Syntax error in query. Incomplete query clause.

[Salgado 4]

Tente assim:

sqlstmt = "SELECT * FROM " & prof & " where id='" & id & "' ORDER BY id DESC"

Note que eu retirei os ' que abraçavam a tabela, não são necessários!