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.