Issues with BE Compacting still pending

Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc used Ask the Experts™
Sorry to bother you people I'm still new in VBA

I remember one of the senior experts mentioning the code below as the best way to compact the BE:

<path_to>msaccess.exe <path_to>be.accdb /compact

Where do I put this code:

<path_to>msaccess.exe <path_to>be.accdb /compact

(1) Should I create unbound form ?
 example :

Private Sub cmdBe _ Click()
<path_to>msaccess.exe <path_to>be.accdb /compact

End Sub

(2) The path issues does it means that I have to open the BE which is password protected?
(3) Can the same code run in a distributed ms access runtime  environment?

I'm highly grateful to you all  for all the contributions you have posted to assist me.


Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Analyst Assistant

That could would be run from the command prompt.

Which version of Windows are you using?

If it's Windows 7/8/10 you can open the command prompt by pressing Windows+R and entering cmd.

You would then need to enter the code you posted replacing <path_to> with the appropriate paths for msaccess.executed and your database.

If you are going to use this on a regular basis you could create a batch (.bat) file with the code and that could be run from a convenient location, e.g. the desktop.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial