I just started trying that (always think of an answer right after I ask for help) so thanks for confirming I'm on the right track.  Much appreciated!

I would like to have seen a more fact and example based argument.  What do these things to do performance and scalability.  Every design decision has to be weighed out...

I agree it is a scary thought and, though not applicable in most cases, will be applied nonetheless.  If I'm hiring an athlete, I do want to know what kind...

Paul, I wish you were my DBA.  The VBScripts are required here because our DBA's refuse to touch a package or ini files once it's tested and sign-off.  I can...

The package is moved from one server to another all the time by generating a script from dev, executing in qa, then executing in prod.  The prod package still has...

We wrap our packages in what we lovingly call core scripts.  They are VBScript that handle all the variables.  We can literally port a package to any server at any...

We do this all the time by way of vbscript (using environmental variables for things like the server.database.login.password) and even using variables for the proc name, file name being processed...

I prefer using 'like' in the where clause and setting the parameter equal to % when the user wants to bypass it.  The order by would have to be handled...

You have my sympathy.  Pass-throughs are a good option, but you have to write them in T-SQL.  If you're users are dumb, they won't be able to do that.  I've...

When you go to XP, which I highly recommend considering MS no longer supports prior desktop OS, you will have even more problems.  Access is meant to be a single-user...

Yes.  All criteria is met.  It executes fine in Query Analyzer, just won't do it when the proc is executed from the app.  It does work if I change the...

Stored procedures are the absolute way to go.  Some app developers like to argue against them b/c they think that equals job security.  Regardless of performance, you still have distribution...

To be more specific, I use ADO to call SP, which runs against view. I'd like to use ADO to call SP, which runs against table.

Thanks for the bit...

I am executing from my local machine. Are you saying that the msdasql provider has to be installed on the SQL server? If so, then that must be...

Use Crystal. The only problem is that the product lifecycle for versions is slim and upgrades are not cheap. Furthermore, versions don't "play nicely" with each other. ...