Results 1 to 3 of 3

Thread: Preventing Duplicate DB values [resolved]

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2002
    Posts
    492

    Resolved Preventing Duplicate DB values [resolved]

    On my ASP site I am getting the following error if I refresh the page once info has been sent to the DB. I see what is happening but what can i do to prevent this error from happening, is there a value that I can set to skipp the addition to the db if the info has already been added.

    This is my error.
    Microsoft OLE DB Provider for ODBC Drivers error '80040e2f'

    [Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

    This is what i use to add data to the db
    rstCustomers.AddNew
    rstCustomers("cst_name") = Request.Form("name")
    rstCustomers.Update


    Any help is greatly appreciated.
    Last edited by mrstuff68; Oct 12th, 2006 at 12:55 PM.

Posting Permissions

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



Click Here to Expand Forum to Full Width