>I've tried....

>oledbCMD.Parameters.Add("@Regarding", OleDbType.LongVarChar, 10, "Regarding")

>Is this correct? It seems to work, but should I beusing something else? Also, it doesn't seem to matter what I put in for the size... I currently have it set to 10 and it doesn't seem to care...


Good question, Rick. I don't know what the difference is between OleDbType.LongVarChar and just plain old OleDbType.VarChar. I'd play with it more if I were you and see if there's any kind of size limitation when using either one.

Or, maybe someone else actually knows and has a better answer than I. <g>

~~Bonnie