Quote Originally Posted by szlamany
Just to add to that - BOF checking is not required after you load a RS from a database - EOF checking is enough. But if there is a chance that the SQL is bad, and no recordset is returned (as opposed to an empty recordset), then you should check the .STATE of the RECORDSET first.
Won't it raise an error in such a case??