Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Table in Access

Discussion in 'Information Technology' started by Denise Carr, Jul 28, 2006.

Tags:
  1. Denise Carr

    Denise Carr
    Expand Collapse
    Guest

    I have a table in access that doesn't have a primary key or index set and
    there are no relationships, it allows me to add 4 records to the table but
    when I try to add a 5th record it come up with the message "The changes were
    not successful because it would create duplicate values" I am not even
    entering the same details. Can any one help with this its driving me mad -
    thanks.
     
  2. Loading...

    Similar Threads Forum Date
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013
    Heritage Now a Vegetable Market, Ranjit Singh's Royal Haveli a Picture of Neglect History of Sikhism Nov 11, 2013
    Sikhism Helium: 1984 and the "Periodic Table of Hate" (Jaspreet Singh) Book Reviews & Editorials Oct 28, 2013
    Heritage How our entire history was dumped in a horse stable History of Sikhism Oct 28, 2013

  3. MNewsGroup

    MNewsGroup
    Expand Collapse
    Guest

    dfsdfsd
    "Denise Carr" <DeniseCarr@discussions.microsoft.com> wrote in message
    news:5CC5B5BB-980C-447B-987B-CC0DB71B5D40@microsoft.com...
    >I have a table in access that doesn't have a primary key or index set and
    > there are no relationships, it allows me to add 4 records to the table but
    > when I try to add a 5th record it come up with the message "The changes
    > were
    > not successful because it would create duplicate values" I am not even
    > entering the same details. Can any one help with this its driving me
    > mad -
    > thanks.
     
  4. MNewsGroup

    MNewsGroup
    Expand Collapse
    Guest

    5555
    "MNewsGroup" <microsoft.public.access@microsoft.com> wrote in message
    news:O48KpCmeGHA.3640@TK2MSFTNGP03.phx.gbl...
    > dfsdfsd
    > "Denise Carr" <DeniseCarr@discussions.microsoft.com> wrote in message
    > news:5CC5B5BB-980C-447B-987B-CC0DB71B5D40@microsoft.com...
    >>I have a table in access that doesn't have a primary key or index set and
    >> there are no relationships, it allows me to add 4 records to the table
    >> but
    >> when I try to add a 5th record it come up with the message "The changes
    >> were
    >> not successful because it would create duplicate values" I am not even
    >> entering the same details. Can any one help with this its driving me
    >> mad -
    >> thanks.

    >
     
  5. MNewsGroup

    MNewsGroup
    Expand Collapse
    Guest

    "MNewsGroup" <microsoft.public.access@microsoft.com> wrote in message
    news:O48KpCmeGHA.3640@TK2MSFTNGP03.phx.gbl...
    > dfsdfsd
    > "Denise Carr" <DeniseCarr@discussions.microsoft.com> wrote in message
    > news:5CC5B5BB-980C-447B-987B-CC0DB71B5D40@microsoft.com...
    >>I have a table in access that doesn't have a primary key or index set and
    >> there are no relationships, it allows me to add 4 records to the table
    >> but
    >> when I try to add a 5th record it come up with the message "The changes
    >> were
    >> not successful because it would create duplicate values" I am not even
    >> entering the same details. Can any one help with this its driving me
    >> mad -
    >> thanks.

    >
     
  6. MNewsGroup

    MNewsGroup
    Expand Collapse
    Guest

    "MNewsGroup" <microsoft.public.access@microsoft.com> wrote in message
    news:O48KpCmeGHA.3640@TK2MSFTNGP03.phx.gbl...
    > dfsdfsd
    > "Denise Carr" <DeniseCarr@discussions.microsoft.com> wrote in message
    > news:5CC5B5BB-980C-447B-987B-CC0DB71B5D40@microsoft.com...
    >>I have a table in access that doesn't have a primary key or index set and
    >> there are no relationships, it allows me to add 4 records to the table
    >> but
    >> when I try to add a 5th record it come up with the message "The changes
    >> were
    >> not successful because it would create duplicate values" I am not even
    >> entering the same details. Can any one help with this its driving me
    >> mad -
    >> thanks.

    >
     
  7. MNewsGroup

    MNewsGroup
    Expand Collapse
    Guest

    Test
    "MNewsGroup" <microsoft.public.access@microsoft.com> wrote in message
    news:O48KpCmeGHA.3640@TK2MSFTNGP03.phx.gbl...
    > dfsdfsd
    > "Denise Carr" <DeniseCarr@discussions.microsoft.com> wrote in message
    > news:5CC5B5BB-980C-447B-987B-CC0DB71B5D40@microsoft.com...
    >>I have a table in access that doesn't have a primary key or index set and
    >> there are no relationships, it allows me to add 4 records to the table
    >> but
    >> when I try to add a 5th record it come up with the message "The changes
    >> were
    >> not successful because it would create duplicate values" I am not even
    >> entering the same details. Can any one help with this its driving me
    >> mad -
    >> thanks.

    >
     

Share This Page