If you're using OpenRecordset to open it, try:

Set rs = db.OpenRecordset(SQL)
If rs.BOF And rs.EOF Then
' It's empty
Else
' It's not empty
End If

If you have something else in mind, please give more details.