Share via

Compacting backend

Anonymous
2020-07-13T12:58:57+00:00

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.

Microsoft 365 and Office | Access | For home | Windows

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.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Anonymous
    2020-07-14T13:36:27+00:00

    Thank you for the information.

    Would I use Run dialog box for xyz.DBEngine.CompactDatabase (parameters)?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2020-07-13T14:47:34+00:00

    Was this answer helpful?

    0 comments No comments