>Hi Tore, This is a temporary database table that needs to be overwritten each day. There's no real need to keep the data and we don't want to manually run a separate Visual FoxPro program to pack the table. Is there a way to pack this as part of a SQL statement or a stored procedure? Thank.
Try with this sending this query: "SET EXCLUSIVE ON;PACK "