I currently use the following code to manually compact a backend database from a desktop icon now and then, when it gets a bit "bloated"
- "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "C:\pisprg\Pisdatav2.accdb" /compact
It would be very nice to add vba code to the application's "exit" button, that will look at the linked BE files and whether another pc is logged into the BE (and warn me), and then compact it accordingly.
I assume this can only happen when nobody is logged into the system from another pc, as that is how i currently do it.
Any suggestions?