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

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

Here is the code I am trying to use,

f = "WHERE week_no = '"&Request.QueryString("sweekno")&"'"
sSQL = "SELECT * FROM " & sTableName & f
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sSQL, db, adOpenStatic

I am using this similarly in another part of this site without trouble, so I don't understand waht's going on.

Thanks in advance.

------------------
Duke