Results 1 to 6 of 6
  1. #1
    edmscan is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Feb 2014
    Posts
    168

    Database compacts on close ...yet "Compact On Close" option is not set ?

    My database .. compacts on close even though the "Compact on Close" option is not set.



    Anyone have any ideas ?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,548
    I have 2:

    1. code somewhere is causing this

    2. corruption
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    edmscan is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Feb 2014
    Posts
    168
    Ok ... thanks. There is no code. That I can assure you cause I would have had to do it .. and I know I didn't. So .. I will make a new file and import all my objects.

    I do notice that there is a Database.mdb file that appears when I close my database .. and it takes a bit for it to disappear. I think that it is compacting at that point ?

    I would prefer just to compact as needed .. not automatically. I will do as above and see how it goes.

    Thanks June

  4. #4
    edmscan is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Feb 2014
    Posts
    168
    Ok .. well that fixed the compacting issue on close. Much better now.

    However .. I tried some code to compact on demand from the quit button on a form, but it does not seem to do anything ?

    http://rogersaccessblog.blogspot.ca/...nt-access.html

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,548
    I've never tried code to run the compact. I just do it manually.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    edmscan is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Feb 2014
    Posts
    168
    Ok .. thank you. I am ok with that. I am not experiencing any problems now.

    Edit .. it appears to be working fine now. I will leave it alone.

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

Similar Threads

  1. How to disable the "close" button in Access
    By Demerit in forum Access
    Replies: 7
    Last Post: 12-08-2013, 07:08 PM
  2. Compact on Close
    By libraccess in forum Programming
    Replies: 2
    Last Post: 05-05-2013, 09:05 AM
  3. Replies: 15
    Last Post: 02-17-2012, 09:20 AM
  4. Compact and Repair Database "Bombs"
    By GraeagleBill in forum Access
    Replies: 16
    Last Post: 09-27-2011, 09:23 AM
  5. "Close form" action does not release table
    By TFisher in forum Programming
    Replies: 7
    Last Post: 07-22-2010, 06:33 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