Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    173
    Thanks
    0
    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
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 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
  •