Automatic Procedure - Email

[DEI]

Is there anyway to program an automatic event in Access, i.e. update query
that runs every night at 10:00 am, etc.?

And, is there any way to program access to perform automation event,
specifically send an email, on its own when not being accessed by anyone?

I would like the database to send a notification email every morning at 5am.

Thanks in advance,

DEI

 

[dch3]

As the other person stated - NO. But you have some options.

1) You can entirely set things up so that a query automatically runs if it
hasn't already been run. It comes down to creating a table where you capture
the last date/time that an event ran. Then in your Startup function, you
check the record for the specific query. If it has not run on today's date,
you execute it. Finally, you run an Update on the table to show the query as
having been run. This assumes of course that you have a Startup function and
preferably a splash screen on which you can give your users a message
indicating that queries are running and to please standby.

2) I'm not the Windows Server guru, but I'm fairly certain that you can
create a task on the server to open the database. I believe that there is a
command line switch that will cause a specific macro or procedure to run. If
not, I do know that theres a user parameter switch that you can use to cause
you're startup code to recognize that its being opened by the server. Then
its a matter of branching out to do what needs to be done and then quit
Access.

See /x and /cmd at http://www.vb123.com/workbench/help/commandline.htm