Any other way?

Results 1 to 2 of 2

Thread: Any other way?

  1. #1
    Join Date
    Dec 1969

    Default Any other way?

    Is there any other way to check if a particular table is empty? I am currently coding it in the manner below.<BR><BR>If Not RSFind.EOF Then<BR> blah, blah,<BR>End If

  2. #2
    Join Date
    Dec 1969

    Default Sure.

    If you use the proper lock type, you can check the .Recordcount property.<BR><BR>Or, you could write a query that returns the count of records from the table:<BR>sql = "select count(field) as record_count from table"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts