Will try, Thanks

Thanks for the help.

Jim

I have a complied program that some other company has written. I must update data in a table that that the complied program runs over. Some of the columns require...

Thanks for the help. Will give it a try.

Thanks for the help Phil. This appears to maybe correct the connections, but what about my tasks. Will this correct all the tasks by changing only the connections?

Thanks, that linked worked and is just what I needed.

Want to delete the data from the table, but it is a live server that I can not tie up the resources of. Truncate could possibly tie up all resources...