Is there anyone out there who has a method of compacting Access 97 databases during silent office hours. The only way I have found in the Knowledge base requires the database to be given a new name when you compact it. The problem I have is a lack of server space so I can't have two copies of the database on the server.