<div>
Try this:<br />
<br />
It works for me:<br />
<a href="http://visualbasic.ittoolbox.com/documents/popular-q-and-a/compact-and-repair-access-database-with-visual-basic-2903" rel="ugc">http://visualbasic.ittoolbox.com/documents/popular-q-and-a/compact-and-repair-access-database-with-visual-basic-2903</a><br />
<br />
Good luck<br />
<br />

</div>


<div>
easiest way is to set the option to compact on close. And simply open and close the database from Excel.<br />
<br />

</div>


<div>
Exactly what I was looking for!
</div>


<div>
<div class="content wysiwyg-content">
I have an Excel VBA routine that updates an Access MDB. How do I perform a compact/repair after the update (from Excel using VBA) so I don't leave the file all bloaty?
</div>
</div>


I have an Excel VBA routine that updates an Access MDB. How do I perform a compact/repair after the update (from Excel using VBA) so I don't leave the file all bloaty?

Try this:

It works for me:
http://visualbasic.ittoolbox.com/documents/popular-q-and-a/compact-and-repair-access-database-with-visual-basic-2903

Good luck



easiest way is to set the option to compact on close. And simply open and close the database from Excel.



Compact MDB from Excal VBA

I have an Excel VBA routine that updates an Access MDB. How do I perform a compact/repair after the update (from Excel using VBA) so I don&#39;t leave the file all bloaty?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.