If I leave my access application open overnight is there a way to schedule a database compress/repair?
If not within access, has anyone used a old fashioned script writer to open the database and compress it?
Maybe even have the database open and close itself doing the compress on shutdown?
Back end database is just getting too big without regular compression and its slowing up everything.