>What is the correct way to pack tables. I open the database in exclusive mode. When i say pack tablename, I get an internal error, and Foxpro is closed. When I try and access my tables, I can't , cause the indexes are then screwed. And I have to remove them and add again. Not even a database validate and recover help.
>
>Thanx Stuart

open data mydata
use mytable exclusive
select myTable
pack

Also I would check the free space on the local drive before doing pack.