Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Compact Database with same name
Message
 
À
22/06/2000 05:13:07
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00383060
Message ID:
00383273
Vues:
21
>I tried to use the CompactDatabase command to free database
>bytes after records deletetion as follow:
>
> DBEngine.CompactDatabase "tt1.mdb", "tt2.mdb", dblangGeneral,
> dbVersion40, ";pwd=pass"
>
>But it has to specify different name for the Source and Destination.
>Can I use back the same name of the database after Compacting?
>As I would like to perform this function everytime I start my
>application (to make it transparent to the users). Any better advise?

Use the Kill statements to delete tt1.mdb and then use the Rename statement.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform