>From: "Yoel Pedersen" <y.pedersen@g...>
>Date: Wed, 20 Feb 2002 08:47:22
>X-Message-Number: 10
>
>Thanks for the suggestions, Cardyin & Toby.
>
>I mean VB when I say "programmatically". The database is located on a
>server where I can't be sure that I am able to install Access 2000 itself.
>So, to compress the db, it would probably be best to do it the manual way,
>copying the data into a new db based on a template and then delete the old
>one. Even though it is much easier for me, just to call a method located
>somewhere in a db component, to compact it..


Make a reference to the "Microsoft Jet and Replication Objects 2.X Library" 
in your VB project - you do not need Access - and you can compact (and 
repair) an Access database, regardless of where it is located (assuming 
proper permissions if on a server).

Regards,
-Toby