Results 1 to 3 of 3
  1. #1
    Bcanfield83 is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    May 2018
    Posts
    81

    Question Compact & Repair multiple BE Databases?

    Good morning,



    Wondering if there's a way to programatically (e.g.: through VBA) do a Compact & Repair on multiple backend databases?
    I have all forms/queries/modules in a frontend DB and then linked tables to 3 different backend DB's. Currently, I have to open each backend DB and then run the C&R.
    Not a huge burden but would be nice to do it all in one fell swoop if needed.

    Thanks

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    you use application.compactrepair - each of the backends must be closed (i.e. no forms open which reference the back end, no recordsets in use, etc by you or any other user)

    https://docs.microsoft.com/en-us/pre...(v%3Doffice.11)

  3. #3
    Bcanfield83 is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    May 2018
    Posts
    81
    Great - thank you!

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

Similar Threads

  1. Compact & Repair
    By Kundan in forum Programming
    Replies: 2
    Last Post: 01-13-2019, 10:24 PM
  2. Compact and Repair
    By cwitt11 in forum Access
    Replies: 4
    Last Post: 12-08-2015, 11:52 AM
  3. Replies: 3
    Last Post: 06-20-2015, 10:18 PM
  4. Compact and repair
    By data808 in forum Access
    Replies: 4
    Last Post: 03-30-2014, 03:22 AM
  5. Compact and Repair
    By Cyberice in forum Access
    Replies: 3
    Last Post: 03-18-2014, 03:22 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