>>People ,
>>
>>How can i easily determine if a table is empty
>>
>>thanks
>
>Considering the other 2 replies to you, what if all the records in the table have been deleted and SET DELETED is ON? Then you would be falsely assuming the table is empty because EOF() would always by true. Issuing a RECCOUNT() on a table will tell you the number of records in the table regardless of the SET DELETED status. A return value of ZERO means the table is empty.

Of course you are correct, but I always Assume that if I have only deleted records then the table is empty. I don't need those records or I would not have deleted them, unless I'm doing something stange, which I have done a time or two. But In that case I would be looking for a deleted record and take that into account

Jeff