Instead of running the code below on run prompt to compile the BE , is there no way we can run it from a form either when opening a start up form? We are given a facility to compact the FE on close .
msaccess.exe /pwd yourpassword /compact "C:\Users\chris.hankwembo\Desktop\HqInfor Premier_Mu.accdb"
I may be wrong but the code above appear to be opening my BE even if it is encrypted and password protected, if I'm right, is there a way to help user run this code at start up form?
A sketch will be highly appreciated.