Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts
    When you compact a database within Access, does it make another copy of the database? On my C drive it doesn't but on my network drive it does.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts
    What should happen is the following:
    1. Create a compacted copy of the current database in the same folder as the current database; the copy is named db1.mdb, or db2.mdb etc.
    2. Close the current database.
    3. Delete the current database from disk
    4. Rename the compacted copy to the name of the now deleted database.
    5. Open the renamed, compacted copy.
    The user hardly sees this, so it seems as if the current database is compacted, while in fact it is replaced by a copy.
    Sometimes, step 2 fails, and then Access cannot perform the remaining steps, so that you end up with the current (uncompacted) database still open AND a compacted copy on disk.

    There was a bug in the original release of Access 2003 SP3 that caused step 2 to ALWAYS fail. This can be corrected by installing the Access 2003 post-Service Pack 3 hotfix package: December 18, 2007.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts