Hi Inigo,
If your need is to cleanup the table from deleted records
physically I'm afraid you cannot do this using ADO. AFAIK he most you can do is mark the records as deleted issuing a SQL-DELETE command and configure your DSN to keep them invisible (in the fashion of a
set deleted on command).
The way to go would be to write a VFP COM component with a specific method that performs the
PACK on the table as Chris said, but considering that you expect a heavy use of the ASP page -and thus frequent access to the table- and that PACK builds a new table and deletes the original one the topic persists unfeasible as you could block any user attempt to see the page during the PACKing of the table.
Shall you consider performing the PACKing everytime you start your web server, invoking the mentioned VFP COMponent on the Application_OnStart event script in the global.asa file.
Hope this helps,
Solo se que nada se
Fausto J. Garcia Pino - MCSD.NET
.NET, Oracle, Tronador & Fondismo!