I'm using VB, with MSDAO 3.60 referenced and am trying to use the DBEngine.CompactDatabase() method. I just have a few questions;

1) Am I right to assume that this will also repair a database?

2) Is there some way to get it to allow the same filepath for both source and destination files? (I know access2000 doesnt seem to have a problem with this...)

3) Is there another, better way to compact and repair a DB without having to juggle filenames?

Thanks