Determing Empty Tables or Queries in MS Access
August 11, 2000
6:08 am
You can determine whether an Access table or query, accessed via RECORDSET OBJECT, contains any record by examining the boolean type BOFand EOF propertyof that RECORDSET OBJECT. If the RECORDSET contains no recordor is empty, then the value of both properties is TRUE, that is, BOF = TRUE andEOF =