I had seen the BOL sentence, but failed to read it carefully enough the first time around to understand how to handle columns that are larger than 8. The BOL...

If there is a way to reference the column that is being tested for update by name (rather than number), then it won't matter whether the column number is 5 or...

Addict's sample code did the trick. I'll keep System.Data.SqlClient for when we migrate to .NET

I don't think that I would have been able to figure it out on my own...

> Dim MyCmd As New SqlClient.SqlCommand("dbo.usp_check_login", MyCn)

SqlClient is not a known object in ActiveX Data Objects 2.7 (Library) ,which define ADODB objects. What library reference do I need to add...

cmdLogin.Parameters.Add() method is apparently NOT supported.

cmdLogin.Parameters.Append(Object) is available, but how do I create an object from the following parameters?

    "@username", adVarChar, adParamInput, 20, sUsername

I recall seeing cmdCommunity.CreateParameter("@username", adVarChar, adParamInput, 20,...