Auto Exec question

[wilhelmmt]

Is there a way to have the database send a notification Email to a user without the database being open?



The Email would be based on date parameters.

If this is not possible, is there a way to automatically open a database everyday at a specified time?

[c_smithwick]

No to the first question. You can automate opening the database, but you would need to use a separate program that would run in the background constantly - known as a TSR or "terminate and stay resident" program, or you can use the native Windows Task Scheduler to open your database at a prescribed time.

[wilhelmmt]

Does the TSR or the Windows Task Scheduler also have the ability to close the database at a specified time?

[TheShabz]

To elaborate a bit, it's not really the Task Scheduler that is opening and closing your database. What would end up happening is that you would write a .bat file that would open your db, and run whatever macro you want, at whatever time you want. It would then run another .bat file that closes the db at whatever time you want. I'm not sure how the Task Scheduler is connected to CMOS, if at all, so I don't know if it would have the capability to actually turn on your computer (turning off the computer isnt an issue). You may have to leave the computer on at all times

[c_smithwick]

Some may, but why don't you just have your database exit after it performs whatever function you need it to do with an Application.Quit call at the end of your function?