Hi,
I'm not familiar much with Access so I don't know if it's possible, but would appreciate any input regarding the following:
Multiple macros from different databases (all located within one folder or sub-folders) are run daily on 6 different schedulers which really hogs their performance as well as takes up a lot of free space. So periodically, we end up manually compacting and repairing large databases to free up space; a tedious process as one can imagine. I was wondering if it's possible to set up a job (either through VBA module or any other way) to run once a week, where I have the code to look at all databases present in a particular folder (as well as its sub-folders); pick DBs with size greater than 200KB, and compact & repair them.
If possible, what would be the best solution to this problem? Please provide complete info on how to do so..Thanks in advance.
Vick
I'm not familiar much with Access so I don't know if it's possible, but would appreciate any input regarding the following:
Multiple macros from different databases (all located within one folder or sub-folders) are run daily on 6 different schedulers which really hogs their performance as well as takes up a lot of free space. So periodically, we end up manually compacting and repairing large databases to free up space; a tedious process as one can imagine. I was wondering if it's possible to set up a job (either through VBA module or any other way) to run once a week, where I have the code to look at all databases present in a particular folder (as well as its sub-folders); pick DBs with size greater than 200KB, and compact & repair them.
If possible, what would be the best solution to this problem? Please provide complete info on how to do so..Thanks in advance.
Vick