here's a link to browse through...

link

The bottom line is that though I did give remi this name it was on a temporary basis but now he won't give it back!!! It appears that something...

noeld - repeat after me - aar - gee - are - us...see how easy it is now ?!

noeld - don't even ask!

by the way i did the right thing and sent you a pm with a "welcome back" msg...for all that remi knows i'm shocked that...

nope! conditions were identical for both scripts...

triggers are to be used more for referential integrity than anything else...when a new sales order is inserted in the database, does your application not get "refreshed" with the added...

that's certainly helpful to know!

Now if only someone would tell me why one of my scripts included dependent objects and the other one...

well - here's another "weird feature" that I came across in my db...I scripted 2 views that have dependent views...one scripted in alphabetical order and the other one didn't script...

Guess the only workaround would be to name the dbobjects with the alphabetical scripting in mind and be creative with making the names both meaningful and in the required alphabetical...

sukhoi971 - you have posted your question in the right forum so hopefully an "ACCESS" savvy person should be along to help you...

May I add though - that an ACCESS...

right assumption...sukhoi971 - your link's not working!

you could try something like this in the master db:

select sd.name, login_time, last_batch, sp.status, program_name

from sysprocesses sp

inner join sysdatabases sd

on sp.dbid = sd.dbid

Raj - nothing in the posts say that you did not delete a system table...I was not giving any other turn to your question except trying to get some information...

however,...

ah - ever the perfect gentleman! thx. remi!

it's no consolation jeff - remi'll tell you (& i'll spare him the trouble of saying so) that it's only a matter of time!