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.
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.
you can compact before and/or after, not during an import
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,
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.