>>how is an efficient way to tell if a table has no active records.
>>
>>thanks, brenda
>
>SET DELETED ON
>COUNT TO nTotal
>IF nTotal=0
>...

Or:

SET DELETED ON
GO TOP
IF EOF()
...