Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Jacksonville, North Carolina, USA
    Thanked 0 Times in 0 Posts

    Backup Database on Exit (11.8204.8202 sp3)

    I have an employee that whenever she exits one of our databases a backup copy is made and is named db1,db2, db3, etc. This happens w/ no one else. How can I make this not happen?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Backup Database on Exit (11.8204.8202 sp3)

    I suspect that "Compact on Exit" has been set for this database in the General tab of Tools | Options...
    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