Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Append query error message (Access 2000)

    Does anybody know what a type conversion failure error means? I

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Append query error message (Access 2000)

    Do you have an autonumber field in the appendquery ?
    If yes, remove it from the query because you may not enter values in that field. Access has to generate them self.
    Francois

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Append query error message (Access 2000)

    Thank you francois but no, I don't have a autonumber feild.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Append query error message (Access 2000)

    Do you have one or more Indexes with No Duplicates set to yes ? (typical for keyfields)
    Maybe you try to append duplicated data for these fields.
    Francois

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Append query error message (Access 2000)

    It literally means that there is data you're trying to append that can't be accommodated by the target field. You'll need to try eliminating fields from the query, one at a time, until you discover which field is causing the problem. Then examine that field and the target field and make sure they are both the same datatype and the same size. For example, a double will not append to an integer. They're both number types but the sizes are very different. You can also get the error if you have nulls in source fields or strings that are being appended to numeric fields, etc.
    Charlotte

Posting Permissions

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