Welcome to SPN

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

Sign Up Now!

Problem with combining tables!!!!

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

  1. Kwgame

    Kwgame
    Expand Collapse
    Guest

    I am trying to combine three tables into one Master table. I have been doing
    this through appended queries. I can get the first appended query to work
    but the next two do not work and I get a message that says "Access can't
    append all the records" and something about conversion failure and validation
    rule violation. I have check all the the fields to make sure they match but
    I still get the error. What can I do? Is there another way to combine the
    tables?
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikhs Face Problems While Carrying Kirpans In Khyber-Pakhtunkhwa - SikhSiyasat.Net Breaking News Jul 29, 2016
    "Dasam" Granth - A Look At The Core Problems Dasam Granth Oct 21, 2015
    Problems In Life Sikh Sikhi Sikhism Apr 13, 2015
    How can I make decent and useful friends and from where ?? most people have a problem with me Sikh Youth Oct 23, 2013
    The Problem with Taking Too Many Vitamins Health & Nutrition Oct 18, 2013

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    The error could be due to several things.

    Some examples:

    a) There is a unique index (primary key, or No Duplicates index) on a field
    or fields, and the data you are trying to add would be a duplicate.

    b) The field has the Required property set to Yes, but the data has no value
    for that field.

    c) The field has the Allow Zero Length property set to No (as it should),
    but the data contains zero-length-strings instead of nulls.

    d) One of the fields is a foreign key to another table, but the data you are
    adding has values that are not in the matching table.

    e) There is something in the Validation Rule of one of the fields in the
    table, and the data you are trying to add does not meet this rule.

    f) There is something in the Validation Rule of the table (Properties box,
    in table design), and the data you are trying to add does not meet this
    rule.

    g) The data you are trying to append does not match the field type in the
    table. For example, you are trying to append the word "unknown" to a date
    field or a number field.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Kwgame" <Kwgame@discussions.microsoft.com> wrote in message
    news:DB6C08C0-CBB7-4821-B2B7-DF3BA977B129@microsoft.com...
    >I am trying to combine three tables into one Master table. I have been
    >doing
    > this through appended queries. I can get the first appended query to work
    > but the next two do not work and I get a message that says "Access can't
    > append all the records" and something about conversion failure and
    > validation
    > rule violation. I have check all the the fields to make sure they match
    > but
    > I still get the error. What can I do? Is there another way to combine
    > the
    > tables?
     
  4. Kwgame

    Kwgame
    Expand Collapse
    Guest

    Thanks, it was the primary key!! :)

    "Allen Browne" wrote:

    > The error could be due to several things.
    >
    > Some examples:
    >
    > a) There is a unique index (primary key, or No Duplicates index) on a field
    > or fields, and the data you are trying to add would be a duplicate.
    >
    > b) The field has the Required property set to Yes, but the data has no value
    > for that field.
    >
    > c) The field has the Allow Zero Length property set to No (as it should),
    > but the data contains zero-length-strings instead of nulls.
    >
    > d) One of the fields is a foreign key to another table, but the data you are
    > adding has values that are not in the matching table.
    >
    > e) There is something in the Validation Rule of one of the fields in the
    > table, and the data you are trying to add does not meet this rule.
    >
    > f) There is something in the Validation Rule of the table (Properties box,
    > in table design), and the data you are trying to add does not meet this
    > rule.
    >
    > g) The data you are trying to append does not match the field type in the
    > table. For example, you are trying to append the word "unknown" to a date
    > field or a number field.
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "Kwgame" <Kwgame@discussions.microsoft.com> wrote in message
    > news:DB6C08C0-CBB7-4821-B2B7-DF3BA977B129@microsoft.com...
    > >I am trying to combine three tables into one Master table. I have been
    > >doing
    > > this through appended queries. I can get the first appended query to work
    > > but the next two do not work and I get a message that says "Access can't
    > > append all the records" and something about conversion failure and
    > > validation
    > > rule violation. I have check all the the fields to make sure they match
    > > but
    > > I still get the error. What can I do? Is there another way to combine
    > > the
    > > tables?

    >
    >
    >
     

Share This Page