I know how to do it- and it works great. The only problem is that the macro needs to fire everyday and I am not there, connected to the network, every day (and I have a laptop that travels with me.) How can I remove the responsibility to run this task from my local machine and have it somehow managed on the server ( like on our "share" drive.) Any other thoughts to accomplish the same end result? Thanks.
Well, you could place the mdb file on the server, if it isn't already, and run the task on the server itself. 1) Create a batch file with the following commands to execute the macro. @echo off msaccess.exe "C:\Path\To\Access\File\mydatabase.mdb" /x MacroName 2) Go to "Control Panel > Scheduled Tasks" and create a new schedule task, pointing to your previously created batch file. The scheduled task wizard is pretty intuitive.
I don't understand. Do you mean go to control panel on the server ? Otherwise I don't see what is different. I don't want to create a scheduled task on my laptop for the reasons stated above.
Yes, on the server. Do everything I mentioned on the server. But the MDB file would have to be located on the same server. I'm saying this because I assume the MDB file is now on your Desktop.
So you are are not server admin... It won't be possible to schedule it on the server. And, since your laptop is not always on site, I can't see how you could do that.
