Thanks I have to restart the SQL to find out so its a late night for me...

Scott Blakeman

"When you do something incredible, try not to look amazed" --someone

Thanks for the help so far...

[A bit of background]

I have an app that updates some table acmem with an adnno (int) I have a trigger on this...

Thanks...

I finally got it to work. The problem turned out to be permissions...

Bah humbug!!!

Thanks for taking the time out help

Regards

Scott Blakeman

"When you do something incredible, try...

No Joy... Is there anyway to see debug msg's?

Scott Blakeman

"When you do something incredible, try not to look amazed" --someone