I'm running WinXP with Access 2003 front end / back end databases. I would like to automatically compact and repair the back end databases on a regular basis. My question is:
1. How frequently should I be running the compact and repair?
2. What is the most efficient way to accomplish this?
I've read questions about using an automated task, and I've also read that I should make a back-up copy before doing the compact and repair. Is that really necessary? If so, then I guess I would need to do a backup first, and then compact and repair.
What's the best approach for this? Thanks.