We help IT Professionals succeed at work.

Issues with BE Compacting still pending

Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc asked
on
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.

Regards


Chris
Comment
Watch Question

Analyst Assistant
Commented:
Chris

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.