Ed and Tom showed you how to USE the table SHARED. One other note... it will be faster to ZAP the table rather than DELETE ALL and PACK, especially if the table has lots of records.
>if anyone can advise what is wrong with the code below... i am trying to empty a table and can't get the exclusive use set to off again once it is packed...
>SELECT book
>if reccount()>0
> USE book excl
> DELETE ALL
> PACK
> SET EXCLUSIVE OFF
>endi
>
>many thanx!
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer