Re: Trigger equivalent in Access?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Sylvain Lafontaine ("Sylvain)
Date: 08/29/04

  • Next message: Steve Jorgensen: "Re: Trigger equivalent in Access?" 
    Date: Sun, 29 Aug 2004 01:58:00 -0400

    Are you talking about an Access database, with a MDB file, or about Access
    as a Front-End with SQL-Server as the Back-End?

    In the first case, the answer is no and for the second, there is no
    difference on the SQL-Server side about triggers when Access is used as the
    FE.

    S. L.

    "bill morgan" <willmorgan@lisco.com> wrote in message
    news:20f701c48d73$a847a6c0$a501280a@phx.gbl...
    > Friends,
    >
    > In SQL Server, I can set a Trigger that will automatically
    > respond to data inserted into Table_A,[Field_1] by
    > inserting that same data into Table_B,[Field_1].
    >
    > Is there any way to accomplish this same effect in Access,
    > independent of forms/reports (and Code-Behind-Forms)?
    >
    > Thanks,
    >
    > Bill

  • Next message: Steve Jorgensen: "Re: Trigger equivalent in Access?"

    Relevant Pages

    • Re: A97 to SQL?
      ... You could migrate your data to a SQL-Server back-end, ... reasonable level of expertise in access (well A97 anyway) in this way. ... frontend - and so have the advantages of big-time backend (e.g.robust ...
      (microsoft.public.access.conversion)
    • Re: Multiple users using the same form with subform
      ... your Access back-end file to a SQL-Server database? ... step in which the tables (now no longer physically present in the front-end) ... If you are converting from Access to SQL-Server for your data store, ...
      (microsoft.public.access.forms)