A family of Microsoft relational database management systems designed for ease of use.
Thank you for the information.
Would I use Run dialog box for xyz.DBEngine.CompactDatabase (parameters)?
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I want to compact and repair the backend of a password protected database. I have searched for a solution but can't find a simple answer to this.
I assume this cannot be done via the frontend (or loading the backend on its own) as the backend would be in use.
Would really appreciate help in getting this done as it hasnt been compacted for many years and is getting quite big. If necessary, I can remove the password protection to accomplish this.
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Thank you for the information.
Would I use Run dialog box for xyz.DBEngine.CompactDatabase (parameters)?
Perhaps you could inspire yourself with
https://www.devhut.net/2020/04/23/access-vba-compact-a-database/