Set rsTable = cnnConnection.OpenSchema(adSchemaTables)

While Not rsTable.EOF


lstrCommand = "select * from [" & rsTable("TABLE_NAME") & "]"
'Open one Table
rs.Open lstrCommand, cnnConnection, , , adCmdText

If Not rs.EOF And Not rs.BOF Then
call ProcessOneTable
end if


Wend

--->The problem is even if my table is empty(no records), but still
rs.EOF and rs.BOF returns False, and go to the CALL ProcessOneTable which
I don't want.

Thanks for help