locktype error! help

I have the following line in my code but I keep getting the error: "Recordset does not support updating. This could be a limitation of the provider or of the current locktype"

RS.Open SQLstatement, SQLCON, adLockOptimistic

Does anyone know if that line is correct or not? I'm using MS SQL Server 2000

Try

VB Code:

RS.Open SQLstatement, SQLCON, adOpenKeyset, adLockOptimistic

Thanks. Works perfect. What is OpenKeyset anyway?

Sets the cursor type, other options are: asOpenDynamic, adOpenForwardOnly, adOpenStatic