why does this doesnt work?

[tchoune]

Ok I have this line that work real good, it paged all throught my records without any problems.

 rs.Open "nametable", connStr, adOpenForwardOnly, adLockReadOnly, _
  adCmdTableDirect

 If Len(Request("pagenum")) = 0  Then
  rs.AbsolutePage = 1
 Else
  If CInt(Request("pagenum")) <= rs.PageCount Then
   rs.AbsolutePage = Request("pagenum")
  Else
   rs.AbsolutePage = 1
  End If
 End If

 Dim abspage, pagecnt
  abspage = rs.AbsolutePage
  pagecnt = rs.PageCount


and so on...

When I try to insert a SELECT in the first line like this:

 rs.Open "Select * from nametable", connStr, adOpenForwardOnly, adLockReadOnly, _
  adCmdTableDirect

I got an erros message
"Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause."

why?

[Spooky]

Try using adCmdText, not adCmdTableDirect