>Hi,
> I am working on a Visual C++ program which access a VFP 5.x database through ODBC. When I delete a record from a table, it is still in the table, but marked as delete. I want to remove deleted records permanently from tables.
>How to Pack the tables through ODBC?
>
>Thanks
>Puri

If you can reindex through ODBC you can pack the table yourself.

Just...

select * from table where not deleted() into table mytable
delete table
copy mytable to table
reindex

Or...

You could also use record recycling too..;.

When you add a record, first do a select to see if there are any deleted. If there are, reuse that record. If there are no deleted you can do an insert into.

BOb