Re: effect of trigger in Access?
- From: "Mary Chipman [MSFT]" <mchip@xxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 23 Jan 2006 08:30:01 -0800
Even if you use SQL Server, you want to avoid triggers as much as
possible. They are good for logging, etc., but not as part of a
transaction because they extend the life of a transaction. This can
cause unintended blocking and deadlocks, depending on your data and
application architecture.
--Mary
On 15 Jan 2006 01:03:14 GMT, "Kevin" <kevind@xxxxxxxxx> wrote:
>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
>> >
>> >
.
- References:
- effect of trigger in Access?
- From: Kevin
- Re: effect of trigger in Access?
- From: Rick Brandt
- Re: effect of trigger in Access?
- From: david
- Re: effect of trigger in Access?
- From: Kevin
- effect of trigger in Access?
- Prev by Date: How to get email addresses in Access query imported into to: line of email
- Next by Date: Re: Linked tables auto resolution over LAN
- Previous by thread: Re: effect of trigger in Access?
- Next by thread: Re: effect of trigger in Access?
- Index(es):
Relevant Pages
|
