>Hi all!
>
>Anybody knows how to compact a MDB using ADO or SQL pass throught ?
>
>
>Is it possible ?
You could use Jet and Replication Objects (JRO); sample code (not tested):
oJE = CreateObject("JRO.JetEngine")
oJE.CompactDatabase("Data Source=" + Source Database With Path, ;
"Data Source=" + Destination Database With Path)
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up