Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    May 2002
    Location
    Provo, Utah, USA
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    OnUpdate for a table (2002)

    I am modifying a table from a web application (not Data Access Pages). I would like to run a certain macro everytime a row is added to a certain table. Is there something like an OnUpdate method for a table?

    Bradley Ross

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: OnUpdate for a table (2002)

    Not with an Access (read that Jet really) database. On the other hand if you are using SQL Server tables, triggers will do the trick for you very nicely. You can set certain default values in tables, so if all you need is a time stamp or something like that, Jet can manage. But there is no event handling for tables (or queries).
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •