Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove deleted records from a table
Message
 
To
11/02/1999 16:48:25
Sammy Derban
Ghana Telecom
Accra, Ghana
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00186785
Message ID:
00186871
Views:
10
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform