Addnew Method with ADO<BR>Vipul Desai - 22 Aug - 01:21:24 PM<BR>--------------------------------------------------------------------------------<BR>I need to add records to an Access Table and I am having an error that states that the Provider does not support this method immediately after the RS.addnew command. My code is below and could someone please help. It is urgent!<BR><BR>&#060;%@EnableSessionState=True Language=VBScript%&#062; <BR>&#060;HTML&#062;<BR>&#060;BODY bgColor=CLAY&#062;<BR>&#060;% Call AddLogisticsNumbers %&#062;<BR><BR><BR><BR>&#060;% Sub AddLogisticsNumbers<BR><BR>Dim ADOConn<BR>Dim Daoconn<BR><BR>dIM RS<BR>dim count<BR>Set ADOCOnn = CreateObject("Adodb.Connection") <BR>Set RS = CreateObject("ADODB.REcordSEt") &#039<BR>AdoConn.Open "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=c est.MDB" <BR><BR>RS.Open "collapsed",adoConn,adOpenDynamic<BR><BR>count = 0 <BR>Do while not RS.eof<BR>RS.Move 1<BR>count = count + 1<BR>Loop <BR><BR>RS.AddNew<BR>Response.Err Description &#039Program Crashes Here.<BR><BR><BR><BR><BR><BR>End Sub<BR>%&#062;<BR>&#060;p&#062;<BR>&#060;/HEAD&#062;<BR>&#060;/BODY&#062; <BR>&#060;/HTML&#062;