>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
Stuart,
You cannot specify table name in the PACK command in VFP 6. You have to open table exclusively first and than issue PACK command.
OPEN DATABASE Mydatabase
USE Mytable1 Exclusive
PACK
--sb--