Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Oct 2003
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    compact creates new db (2003)

    morning...

    When I run the Compact & Repair on my database...it automatically creates a new database calling if DB1.mdb while leaving the original the same...without any compressing or anything.

    I have no idea why...it used to compact/repair the original.

    Any help would be apprecited.

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: compact creates new db (2003)

    There is a bug in Access 2003 SP3 that disallows the original database to be replaced with the compacted one, so the compacted database retains the default name it is given when it is created: db1.mdb, db2,mdb etc.
    The solution is to download and install 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
  •