PC Review


Reply
Thread Tools Rate Thread

Re: Trigger works in EM but not in ADP MS 2007

 
 
a a r o n _ k e m p f
Guest
Posts: n/a
 
      22nd Dec 2008
I believe that when you update against a view, you're most likely
going to be sending direct edit statements against the table (that
you're editing) which is hopefully the same as the 'uniqueTable'
property of that form.

I've never looked at 'Instead of' triggers, but those are supposed to
do what you're asking for, IMHO






On Nov 28, 1:40*pm, "jacobusroos" <u47871@uwe> wrote:
> Hi,
>
> I found a problem for which I cannot find the root :
>
> In ADP when updating my view via normal view mode or Form mode it won't fire
> my trigger.
> In Enterprise Manager it works just fine with out problems.
>
> Does ADP UI (MS 2007) update its view and forms via update statement or is it
> done via other means ?
>
> My Aim is to keep an audit trail of all changes made on a table via user
> working on the UI in adp. But this approach leaves me banging head against
> keyboard.
>
> Best Regards
> J.Jacobus Roos


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Reports From 2000 ADP to 2007 ADP Martin Microsoft Access Reports 1 26th Mar 2007 02:48 AM
Update trigger works in SQL Server but NOT in Access adp datasheet Bonno Hylkema Microsoft Access ADP SQL Server 5 30th May 2006 04:45 PM
SQL INSERT trigger side effects not always displayed in ADP front end without refresh Malcolm Cook Microsoft Access ADP SQL Server 4 23rd Jun 2004 10:17 AM
works in adp but not in ade Robert Batt Microsoft Access Forms 0 23rd Dec 2003 04:06 PM
Expert Question - Access ADP and Instead of Trigger JMagaram Microsoft Access Queries 0 4th Sep 2003 03:27 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:27 PM.