Results 1 to 3 of 3
  1. #1
    Kundan is offline Competent Performer
    Windows XP Access 2013 32bit
    Join Date
    Mar 2018
    Posts
    155

    Compact & Repair

    1. What is the benefit of “Compact & Repair” Option?
    2. For a Split DB is it required for both Front End & Back End?
    3. If the ribbon is removed for security reason can the compact and repair be done through Code?


  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    1. a.if there is lots of deletion of records, it actually removes them and reduces the db size.
    b. sometimes a form/report/object can get corrupted, and repair fixes this.

    2. BE yes if the db gets too large. FE not needed as much, since theres no large tables to cause it to enlarge.
    and if corrupted, you can always just give the user another copy of FE.

    3. yes, the FE code can be used to compact the BE.

  3. #3
    Kundan is offline Competent Performer
    Windows XP Access 2013 32bit
    Join Date
    Mar 2018
    Posts
    155
    Quote Originally Posted by ranman256 View Post
    1. a.if there is lots of deletion of records, it actually removes them and reduces the db size.
    b. sometimes a form/report/object can get corrupted, and repair fixes this.

    2. BE yes if the db gets too large. FE not needed as much, since theres no large tables to cause it to enlarge.
    and if corrupted, you can always just give the user another copy of FE.

    3. yes, the FE code can be used to compact the BE.

    Thanks a Lot ! GOD BLESS YOU!!!

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

Similar Threads

  1. Compact and Repair
    By cwitt11 in forum Access
    Replies: 4
    Last Post: 12-08-2015, 11:52 AM
  2. Compact & Repair Code
    By aamer in forum Access
    Replies: 6
    Last Post: 11-04-2014, 03:51 PM
  3. Compact and repair
    By data808 in forum Access
    Replies: 4
    Last Post: 03-30-2014, 03:22 AM
  4. Compact and Repair
    By Cyberice in forum Access
    Replies: 3
    Last Post: 03-18-2014, 03:22 PM
  5. Compact and repair on close
    By colotazzman in forum Access
    Replies: 2
    Last Post: 05-20-2010, 02:04 PM

Tags for this Thread

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