• 0

Access 2013 and SQL 2012 help needed

Asked by riot,

 Share

Question

Rising Star

riot

Posted
Posted

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!

1 answer to this question

Recommended Posts

  • 0
Rising Star

riot

Posted
  • Author
Posted

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!

This topic is now closed to further replies.
 Share
Go to question listing

  • Posts

    • China's lunar lander aces touchdown and takeoff tests ahead of planned 2030 crewed moon mission

      By +thexfile · Posted

      China's plan to launch astronauts to the moon has taken a major step forward. The country subjected its "Lanyue" two-person lunar lander to a comprehensive landing and takeoff verification test this week at a unique facility in Huailai County, in northern China's Hebei Province. Lanyue, whose name means "embracing the moon," is a crew-carrying lunar descent and ascent vehicle that's being developed for China's first human lunar exploration mission, which is slated to occur before 2030. The test, completed on Aug. 6, represents a key step in the development of China's human lunar exploration program. It marked the first time that China has carried out a trial for the off-Earth landing and takeoff of a crew-carrying spacecraft, according to the China Manned Space Agency (CMSA). https://www.space.com/astronomy/moon/chinas-lunar-lander-aces-touchdown-and-takeoff-tests-ahead-of-planned-2030-crewed-moon-mission-video    
    • What are the top remote desktop tools for IT support?

      By +Mud W1ggle · Posted

      Anydesk here avoid TeamViewer like the plague, its pure and utter evil
    • Bad news for HBO Max users: the company's about to shut down password sharing "aggressively"

      By +thexfile · Posted

      The torrent must flow.
    • Fan Control V230

      By Copernic · Posted

      Fan Control V230 by Razvan Serea Fan Control is a powerful and versatile portable utility that allows you to monitor, control and customize the fans of your GPU and CPU to keep your machine cool and running smoothly. Fan Control supports a wide range of devices and hardware configurations, giving you complete control over your computer's cooling system. Fan Control backend is mainly based on LibreHardwareMonitor, an open source fork of the original OpenHardwareMonitor. This means that hardware compatiblity is entirely open for anyone to contribute, and doesn't rely on a single developer who may stop caring at some point. Combined with the plugin system, Fan Control is unlocked for many generations of hardware to come. Main features Guided setup process on first launch Save, edit and load multiple profiles Change the theme and color of the application. Multiple temperature sources ( CPU, GPU, motherboard, hard drives... ) Multiple fan curve functions, including a custom graph Mix fan curves or sensor togethers (max, min, average) Low resource usage Advanced tuning with steps, start %, stop %, response time and hysteresis FanControl V230 changelog: Update LibreHardwareMonitorLib (ITE IT8696E lost controls) Update translations Download: FanControl V229 | Installer ~15.0 MB (Open Source) View: Fan Control Homepage | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • Donald Trump calls for Intel CEO to resign over suspected CCP ties

      By leonsk29 · Posted

      "Conflicts of interest", says the man that put Elon Musk, Mr. Conflict of Interest #1 Himself, in charge of a government agency supervising his own contracts.

  • Recent Achievements

    • First Post
      EzraNougat earned a badge
      First Post
    • One Month Later
      westDvina earned a badge
      One Month Later
    • Community Regular
      Bern@rd went up a rank
      Community Regular
    • Week One Done
      Joey Solo earned a badge
      Week One Done
    • Week One Done
      Vicente C Alves earned a badge
      Week One Done

  • Popular Contributors

    1. 1
      +primortal
      711
    2. 2
      +FloatingFatMan
      200
    3. 3
      ATLien_0
      163
    4. 4
      Xenon
      130
    5. 5
      wakjak
      110
    Show More

  • Tell a friend

    Love Neowin? Tell a friend!