>Hi all'
>
>How can I actually remove deleted records from a table.
>(like pack in VFP)
>
>Thanks in advance.
Which DB are you using?
If you use engines like SQL Server, Oracle, Sybase, ... , you can't pack your DB. It is done automatically. You can do maintenance job on your server but there is no real pack.
If you use Access, you can use DBEngine.CompactDatabase method (in DAO). Access requires you to pack at some times.
If you use others (like Dbase files), you will have to write a small application (in Clipper or other) that send a Pack statement on your files.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com