Coffee, Coffee and more coffee with an occasional muffin thrown in for breakfast...

RE:Moreno

That's absolutely correct, when you change permissions for a user running a service, it's the same as changing rights for your own...

so you don't need to worry about versoin now?  or will the MAX(orderDate)always give you the correct date?  IF so how about this...

UPDATE MAIN_TBL

SET MAIN_TBL.Date_Rtn = MAX(LnkS.CUS_DATE)...

I've seen those sort of solutions put into place for network shares and such, but never on SQL server Permissions.  IMHO it would basically be like creating a Null share,...

Can you give a bit more in the way of example data?  For instance how do you know what the ordernumber is? (which btw I'd sugest not using # in...

Yes, it was there, then Steve took care of it, Now it's back however as of 1358 EST.

-Luke.

Unless you specify the xp_cmdshell Proxy Account XP_cmdshell will execute under the rights of the user that the SQL Server runs as.  If that account doesn't have rights to start...

yep, that's the right file then... any chance you could create a DSN that points to the access db?  Then use the DSN fo ryour DTS connection instead of a...

hence the "s in the original post.

thanks again.

I beleieve you hit the nail on the head.  Seems that was the issue.  they were joining two text columns using an int in one table and text in the...

It's a straight access table.  I beleive there is a problem with the way that access is handling the join to a lookup table.  I cleared all of the records...

I'm guessing you already tried the good old Admin, blank password default?  Also, you might check and make sure that it's actually the system.mdw that is protecting the db.  It...

I've only been in the IT business about 10 years, I've done all manner of things from independant consulting to wokring for the state and fed government.  Although I'm no...

Very Slick, quick too.  Have to add that one to my Crazy String Manipulation repository.

Again, I'm not looking for real data, I'm looking for some sample data that could help me get a better understanding of what you were trying to do with the...