2 posts in this topic

We are in the process of converting to a SQL 2012 backend for all of our Access 2013 databases. We are moving all the data tables into SQL and leaving the forms in Access. I am trying to create a SQL trigger that will send an email when a table is updated. For some reason, the email will not send. I've already set up SQL Email and confirmed it is working. When the table is updated by Access, no email is sent. But if I update the SQL table manually, the email is sent. Does Access update tables in such a way that the trigger wouldn't work? Thanks!

Share this post

Link to post
Share on other sites

Wow, 81 views and no ideas! Didn't mean to stump everyone! I figured out the problem though. It was permissions. The database users had no rights to the msdb database. That is why I could update the table (as sa) and the email worked, but updating the table through Access failed. Once I gave the group appropriate rights to the msdb database it started working great!

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.