AddNew, Update, and the old "not supported by prov

Results 1 to 2 of 2

Thread: AddNew, Update, and the old "not supported by prov

  1. #1
    Steve M. Guest

    Default AddNew, Update, and the old "not supported by prov

    Hi there. I&#039ve been trying for literally a month to figure out why I can&#039t get seemingly simple methods like AddNew to work. <BR><BR>I know it&#039s come up here many times, but all I&#039ve been able to find are questions rather than answers.<BR><BR>Does ANYONE have any idea why it is that when I use the statement<BR>rs.AddNew, I keep getting the "not supported by provider" error?<BR><BR>Anyone? Thanks!<BR><BR>Steve M.

  2. #2
    Join Date
    Dec 1969

    Default RE: AddNew, Update, and the old

    You are probably not using the correct cursortype. adOpenForwardOnly is the default and allows only forward movement thru your recordset. Use the adOpenKeySet cursor to add a new record to your recordset. For example<BR><BR>Set rs = Server.CreateObject("ADODB.Recordset")<BR>rs.Curso rType = adOpenKeyset<BR>rs.AddNew<BR><BR>etc.<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts