Re: effect of trigger in Access?

What I was hoping for was record-level locking and record-level
triggers. I'm thinking I should be poking around in a MySQL or SQL
Server area.

mdotau> wrote:

> Rick, completely correct, but note that there is a more
> complicated way of understanding that. :-).
>
> When using the default Jet database (tables in an mdb file),
> you can use declarative referential integrity to cascade
> updates an deletions through your other tables. So unlike
> other database systems, there was not a need to handle
> table level events (triggers).
>
> Other database systems like SQL Server which couldn't
> handle declarative referential integrity have had it retro-fitted,
> and also have retained table level events (triggers) for more
> complex actions like those handled by form level events in
> Access.
>
> In contrast, Access has stagnated for 10 years. SQL Server
> got DRI, Access/Jet did not get table level events.
>
> (david)
>
> "Rick Brandt" <rickbrandt2@xxxxxxxxxxx> wrote in message
> news:HT5yf.785$F_3.196@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > Kevin wrote:
> > > With Access 2000 or 2003, is there a trigger or onChanged method?
> > > I would like to be able to do a mailto if certain fields change
> > > in my db.
> >
> > When using the default Jet database (tables in an mdb file) there
> > are no
> table
> > level events (triggers) as there are in server based systems like
> > SQL
> Server.
> > Only when the changes are done via forms can use the varuious
> > events that automatically fire in forms for stuff like this.
> >
> > Of course Access can easily be used with tables on a server
> > database and
> then
> > Triggers on that system could be set up.
> >
> > --
> > I don't check the Email account attached
> > to this message. Send instead to...
> > RBrandt at Hunter dot com
> >
> >

.

Relevant Pages

  • Re: Problem with bulk load security.
    ... The only user that didn't have the bulkadmin roll was the ID that SQL ... Did you to EXECUTE AS USER or EXECUTE ... Links for SQL Server Books Online: ... DDL Triggers with Server Scope and logon triggers ...
    (microsoft.public.sqlserver.security)
  • Re: User and Login auditing
    ... create triggers on system tables and then you will find out ... and hope that your employer doesn't mind you putting the SQL ... Server box in this position. ... You could put triggers on your trace table. ...
    (microsoft.public.sqlserver.security)
  • Re: effect of trigger in Access?
    ... Even if you use SQL Server, you want to avoid triggers as much as ... >> and also have retained table level events for more ...
    (microsoft.public.access.externaldata)
  • Re: Need to interface MS SQL in C++...
    ... Before worrying about C++ routines I'd use the SQL Server's Linked ... "Observer Pattern" that will "push" the data on the ODBMS db. ... Conversely, if the ODBMS db has triggers, create them on the tables that ... you want to "push" data into the SQL Server db. ...
    (microsoft.public.sqlserver.programming)
  • Re: Need to interface MS SQL in C++...
    ... Before worrying about C++ routines I'd use the SQL Server's Linked ... "Observer Pattern" that will "push" the data on the ODBMS db. ... Conversely, if the ODBMS db has triggers, create them on the tables that ... you want to "push" data into the SQL Server db. ...
    (microsoft.public.sqlserver.clients)
Quantcast