SQL 6.5/VB 6 "Read Only" Error

Hi all!

This is my first time to use SQL Server with VB, so if I've left out any relevant information, please let me know.

Here's my problem: When I try to execute the RDO AddNew method, I get an error -- "The Resultset is Read Only." When I click on the debug option, the code has stopped at the .addnew line.

When I connect to the SQL database, I use this code:

Set gcnPRP = rdoEnvironments(0).OpenConnection( _
dsName:="PropertyControl", _
Prompt:=rdDriverNoPrompt, _
Connect:="uid=pgmr;pwd=blue;driver={SQL Server];" & _
"server =nt3,database=testpropcontdb;")

and:

Set grsPRP = gcnPRP.OpenResultset(gstrSQL, rdOpenDynamic, rdConcurRowVer, rdExecDirect)

I would really appreciate a gentle nudge in the right direction, even if it's only a recommendation for further reading I could do.

Thanks so much!

Elizabeth Fisher