Is there a way of doing a Compact AND Repair on an Access 2000 database from script?<BR><BR>I want to do it as happens in Access 2K where it simply Compacts the current database into the same location.<BR><BR>So far I&#039ve managed to use the Jet CompactDatabase command but it Compacts the database to *another* location. I guess the db gets compacted into a different workspace and then you have to write script to Replace the original file with the Compacted copy.<BR><BR><BR>Darren<BR>darren@showusyourcode.c om