I am supporting a 2003 Access database with a front and backend and I know almost nothing about Access. It appears if I run the Compact and Repair Databse command from within Access that will only compact the frontend. I searched and found a bunch of stuff on comacting the backend but to be honest I don't understand what they are talking about or where to start. Can someone walk me through running a compact command on the backend?
DBEngine.CompactDatabase "Northwind.mdb", "Northwind_compacted.mdb"
If you go MX's rounte, save that as a batch file and run from task scheduler in off-hours if you don't want to do it manually.