Error Adding a New Record

Results 1 to 2 of 2

Thread: Error Adding a New Record

  1. #1
    Join Date
    Dec 1969

    Default Error Adding a New Record

    I&#039;m attempting to update a new record without an error occurring. Here is the code.<BR>&#060;%<BR>&#060;!--<BR> // Connect to the Database<BR> openstring = ";driver={Microsoft Access Driver (*.mdb)};DBQ="<BR> openstring = openstring & Server.MapPath("databasetest.mdb")<BR> <BR> // Open the Recordset<BR> Set Rs = Server.CreateObject("ADODB.Recordset")<BR> "Names", openstring<BR> Rs.addNew FirstName, "Will"<BR> Rs.close<BR> Set Rs = Nothing<BR>%&#062;<BR>The error says that the addNew command is not available. Anybody know why?<BR>Thanks in advance.

  2. #2 Guest

    Default RE: Error Adding a New Record "Names", openstring,adOpenKeyset,adLockOptimistic

Posting Permissions

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