Access 2007 send notifications automatically

Posted on 2012-09-13
Last Modified: 2012-09-18
i have several dbs that have the ability to open and send notifications through our outlook mail system to a prepopulated list of people as a result of pressing a cmd button to send the notifications.  I would like to set these to be sent based on date and time, like every friday at 8am or somehting.  Problem is, from what i have found, i can only send if the db is opened, but there are many times that they may not be opened on that specific day. How can i go about making these send automatically based on a date/time regardless of whether or not a user goes in and opens the db.  I'd like to remove as much of the manual process as possible.  
Question by:LadyHagood
    LVL 29

    Accepted Solution

    Well you could always use Windows Task Scheduler to open the database with a command line argument to run a macro that starts the emailing procedure.  Here's a link to command line arguments you could use.  The one I think would for you is /x.

    Author Comment

    great. can this be used on a db stored on a network and used by many users?  Would this just be scheduled say on the admins pc?
    LVL 29

    Expert Comment

    I would create the scheduled task on a pc that will not be in use at the time.  It doesn't matter if the db is on a network.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Find out how to use dynamic social media in email signatures with this top 10 DOs & DON’Ts.
    Set OWA language and time zone in Exchange for individuals, all users or per database.
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now