I was told to put everything in stored procedures for security reasons and anything that needed to be done to the procedures could be done on the SQL server and I wouldn't have to change anything in ...

Sometimes you do and sometimes you don't.<BR>For example the ADODB connection object has the methods open and execute. For open, you pass the arguments w/o parenthesis and for execute you pass with ...