Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update Query Error (A2k)

    I'm getting a validation rule violation on approx 900 records when I try to update them. I've stepped through each field I'm updating, and it's not just one of them, it's all of them. I've checked the field types/validation rules, etc on each field, they're identical. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Update Query Error (A2k)

    Can you provide details? What exactly are you trying to update, and how?

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update Query Error (A2k)

    Sorry. I have an external data source that - if I had Oracle - I could link directly to my database, however there is some level of human intelligence required nonetheless. Well, since I don't have oracle, I must run queries external to access through Cognos Impromptu. I save the files as excel with format, and then import them into my database as tables, where I run update queries to update personal information on servicemembers. They are all text fields. I've done this 100's of times before, but today I get this error.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Update Query Error (A2k)

    Could it be that the imported information contains zero-length strings? By default, text fields in Access don't accept those. To test, you can try setting the Allow Zero Length property of text fields in the table(s) to be updated to Yes.

  5. #5
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update Query Error (A2k)

    Do you accept PayPal? <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> <img src=/S/hailpraise.gif border=0 alt=hailpraise width=27 height=22>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Update Query Error (A2k)

    In my copy of Access 2003, the default for the "Allow Zero Length" is now yes.

    I don't this is a setting I have changed.
    Regards
    John



  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Update Query Error (A2k)

    Thanks for the heads-up. I just checked in Access 2002, and noticed that the default is Yes there too. Unless my memory betrays me, it was No in Access 97.

  8. #8
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update Query Error (A2k)

    The default in A2K is No, so I'd assume it was for Access 97 as well.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

Posting Permissions

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