>>Hi Gang!
>>
>>Question....
>>
>>How to QUICKLY determine if table does not have any records.... period.... deleted or otherwise....
>>
>>I could use RECCOUNT, but this will have a performance hit eveytime I use it on large tables (I guess) .....
>>
>>What other techniques do you use?
>>
>>Thanks!
>
>The only way you can have a performance problem with reccount() is, not with the function itself, but in opening the table - for example, if it starts with thousands of deleted records, and you have SET DELETED ON. Also, some users have reported performance problems (again, when opening tables), with certain antivirus products.
Thanks!
Tommy Tillman A+ NetWork+ MCP