Results 1 to 3 of 3
  1. #1
    libraccess's Avatar
    libraccess is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Napier New Zealand

    Compact on Close

    I have just found that "package and sign" unticks - the option compact on close (maybe it's the unpacking that does that but hey)
    I have looked at compact and repair by VBA there seems to be a lot of suggestions out there
    has anyone had experience here


  2. #2
    Bob Fitz is online now Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Essex UK
    Are you sure you want to Compact on close? The following link may be of interest:
    If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
    Not everyone can access an accdb, you may reach a broader audience by attaching in mdb format.

    Bob Fitzpatrick

    I have never failed. I have found a thousand ways that do not work!

    Microsoft Community Contributor Award (2011)

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Richmond (Virginia, not North Yorkshire!)
    Pay particular attention to Roger's fourth point! Paradoxically, as he pointed out, compacting is a recognized cause of corruption and should only be done after making and safely storing a backup copy of the database.

    Linq ;0)>
    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access db nuked after compact?
    By Feuerstein in forum Access
    Replies: 4
    Last Post: 02-13-2012, 09:16 AM
  2. Compact & Repair, Will I Run Into Problems?
    By robsworld78 in forum Access
    Replies: 1
    Last Post: 01-10-2012, 05:11 PM
  3. Replies: 2
    Last Post: 06-20-2011, 03:10 PM
  4. Compact and repair on close
    By colotazzman in forum Access
    Replies: 2
    Last Post: 05-20-2010, 02:04 PM
  5. Loss of privileges After Compact
    By jonsuns7 in forum Security
    Replies: 1
    Last Post: 02-01-2010, 05:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums