Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2006
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error 3022 (2003)

    I'm continuously getting Error 3022 anytime I try data entry in the subform: "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. (Error 3022)
    You tried to duplicate a value in a field that is the underlying table's primary key or an index that does not allow duplicates. The message includes the following instruction: 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."

    I inherited this form so I don't know too much about it. But I'd appreciate it if someone could tell me how to make this thing work properly.

    Steve

  2. #2
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Cincinnati, Ohio, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error 3022 (2003)

    Steve:

    Kindly consider posting a copy of your DB with confidential data removed. The attachment limit is 100 Kb.

    http://www.wopr.com/cgi-bin/w3t/faq_...pl?Cat=#attach

    I didn't spot anything horrendously bad in your code.

  3. #3
    New Lounger
    Join Date
    Sep 2006
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error 3022 (2003)

    A stripped-down version of my DB is running around 7000Kb. Good to know nothing's wrong with the code though.

  4. #4
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Cincinnati, Ohio, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error 3022 (2003)

    The code is only half of the problem. The underlying issue is that either the key fields are improperly defined, or that a form is not setup properly to add new records.

    Without looking at the DB, it is guesswork.

Posting Permissions

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