<div>
Hi Rey,<br />
Thank you for your quick response.<br />
<br />
Is there a way to lock the database through VBA as well while performing the C&amp;R?
</div>


Hi Rey,
Thank you for your quick response.

Is there a way to lock the database through VBA as well while performing the C&R?

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have databases with tables that are utilized by an Alteryx application as input and output. The end user will not be opening the databases.<br />
<br />
The issue is the growth of the databases due to internal Access operations which can be close to 1GB in some instances.<br />
<br />
Is there a way to set Compact and Repair for these databases without opening them?<br />
<br />
Thanks
</div>
</div>


Hello,

I have databases with tables that are utilized by an Alteryx application as input and output. The end user will not be opening the databases.

The issue is the growth of the databases due to internal Access operations which can be close to 1GB in some instances.

Is there a way to set Compact and Repair for these databases without opening them?

Thanks

How is a Compact and Repair performed on a database that is not opened?

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.