I have an order management database that is split into FE and BE. I have copied the FE onto every user's PC. Each time the user works on the FE and closes it after some work on forms/reports...., the size of the FE keeps increasing. I am not making any design changes to the FE so not sure why the size keeps increasing. Is there a way to automate the compact and repair function of the FE through VBA by clicking a button on the startup form.
Can anyone please help?
Can anyone please help?