Results 1 to 4 of 4
  1. #1
    kacocal is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2015
    Posts
    26

    Compact thesize of MS Access Database

    Hi all,



    It may be a very simple question, but I really want to have a solution for it.

    Are there any way to compact the size of MS Access database while I am importing data into MS Access?


    Please advice.

    Thanks.

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    you can compact before and/or after, not during an import

  3. #3
    kacocal is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2015
    Posts
    26
    Hi Ajax,

    Thank you for your respond. Let me be more specific. Is there a way when I am running VBA in an MS Access 2007 database and want to compact the database during the run.
    E.g., start vba code which runs some queries that create some large tables and then database compacts and then run some more queries creating more large tables and compact again etc.
    Thanks!

    Do you have any insight for me?

    Thanks,

  4. #4
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    you can run code to compact a db, but not the db the code is running in. see this link

    https://msdn.microsoft.com/en-us/lib.../ff193242.aspx

    google 'application.compactrepair' for more information.

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

Similar Threads

  1. Split Database | Compact and Repair
    By mrmmickle1 in forum Access
    Replies: 4
    Last Post: 07-27-2015, 08:53 AM
  2. Compact and Repair Encrpyted Database Problem
    By mrlddst in forum Security
    Replies: 16
    Last Post: 05-06-2014, 01:24 PM
  3. Unable able to compact BE Database
    By crowegreg in forum Access
    Replies: 3
    Last Post: 01-30-2014, 09:02 AM
  4. Will database auto compact and repair on the server?
    By squirrly in forum Programming
    Replies: 8
    Last Post: 04-15-2013, 02:37 PM
  5. Compact/Reapir doe not reduce database size
    By nosrepmodnar in forum Access
    Replies: 1
    Last Post: 10-23-2009, 02:38 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