Brain dissolve - record count [Resolved]

[salvelinus]

How do I find out the recordcount of a table? I don't know if my brain's dissolving or a problem with Access (help files are disappearing, so maybe...)
I had

dim db as database
dim rs as recordset
set db = currentdb
'error on next line - type mismatch
set rs = db.openrecordset("select * from tablename")
if rs.recordcount > 0 then
....
else
....
end if

I swear this works in at least Access 97, but not in 2000. I know this is simple but I'm blanking out on it. Thanks.