Access Experts,
I have been struggling to find a good solution to that... but can't find an easy on the web. I would like at mid-night everyday, my backend database is being compacted. (i.e. it compacts itself automatically without an user intervention)
If this can not be done, perhaps the front end database can be left running and it fires the VB Code to auto compact its linked password protected backend database? Any insight? Ty
Sincerely,
Perry