I'd like to automatically repair and compact my database but NOT every time its used because it takes a very long time to run the procedure on some of the PC's on the LAN - some are old and slooooowwww.
Is there a way to schedule a compact and repair say once a week using some code or using a bat file to open the db and start a macro that will run the compact & repair and close the db?
Is there a way to schedule a compact and repair say once a week using some code or using a bat file to open the db and start a macro that will run the compact & repair and close the db?
