I haven't used the .refresh method myself, but here's how I believe it is:<BR><BR>the refresh method retrieves info from the provider (e.g. a stored proc) about the parameters. I think you shouldn't use this but just append the parameters manually using the .append method. The .refresh is really resource intensive. <BR><BR>Any particular reason you don't want to use the .append method?
.. without doing the .Refresh, I have to update my code when the stored procedure has optional arguments added.<BR><BR>If I do the .Refresh, my code works quite happily.<BR><BR>And with the suck-a$$ DB team that they have here, stored procs change the DAY BEFORE A RELEASE AND THEY DON'T TELL ANYONE!<BR><BR>Whoops. I exploded. Oh, nevermind - I'm ranting.