Adding a new record using ADO

[tseh]

I am receiving messages that my &quot;database or object is read-only&quot; when I run the following code:<br><br> 'Add to Database<br> Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot<br> rs.open &quot;tblCritique&quot;, cxn,2 , 3<br> rs.AddNew<br> rs(&quot;Critic&quot = strCritic<br> rs(&quot;MovieID&quot = strMovieID<br> rs(&quot;Comment&quot = strComment<br> rs(&quot;Summary&quot = strSummary<br> rs(&quot;Value&quot = strValue<br> rs.Update<br> rs.Close<br><br>My connection works. I am just trying to add these strings into my database.<br><br>What am I doing wrong?<br><br>Thanks<br>

 

[DannyB]

Solution 1:<br>&nbsp;&nbsp;check if 2 , 3 correspond to adOpenDynamic , and adOpenOptimistic respectively. i personally would use &quot;select * from tblCritique&quot;.<br><br>Solution 2: Use cxn.execute &quot;insert into tblcritique (colNames , [..]) values (val1, val2 [..]) &quot;<br><br>The 2nd version is more powerfull.<br><br><br> <p> <br><a href=mailto: > </a><br><a href=

http://dba.8m.com>

</a><br>

http://dba.8m.com

 

[LuvASP]

Your recordset cursor needs to adOpenDynamic, or adOpenOptimistic like the dude before me wrote.