Solve : Scheduling an .mdb compact and repair?

1.	Solve : Scheduling an .mdb compact and repair?
Answer» Hi Hopers, I'm pretty sure this one isnt too CHALLENGING, but i cant seem to find the solution. I need to set up a script/ scheduled task to perform a compact and repair on an access database file. I PRESUME it is POSSIBLE to do this without buying third party software??? Cheers Ben UK PS I'm running Access 2002 (though I can use 2003 if its easier) with XP or 2000 on my workstation.No problem. Run Access with the command line switch /compact, and any other relevant options. For more info, read >here<.BRILLIANT, that works a treat cheers Ben UK

Discussion