Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2006
    Posts
    157

    Red face Unanswered: Records Getting Corrupted

    hi everyone,

    just asking for your thoughts on this matter

    have a table with fields that have formatting i.e. decimals have only 2 digits after the decimal pt. although these fields are not required

    problem lies when updating these records, and the values are omitted, or set to null

    the record gets corrupted, cannot be referenced, deleted etc.

    only way to clean them was via repair

    thanks for your time guys
    Only quitters quit!

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    What is your method for your updates?
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Apr 2006
    Posts
    157
    i've just used access' default for this one
    Only quitters quit!

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by syntaxerror
    i've just used access' default for this one
    That means squat to me ... Access doesn't have a "default" update ...
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Apr 2006
    Posts
    157
    um, yah, it's in the docmd thing, when you create a button and the wizard helps you to a save button...

    but, i know , i know, it's my fault, i was using sql queries to perform some updates on the same record in between the time the form accesses it and the time the save button is clicked...

    it's like form is in edit mode, user creates changes, sql query updates some fields on the record, then user saves...
    at times i'd get a pop-up of record write conflict

    i'm a big sinner this way... anyway, i just scrapped the sql query and updated the fields directly as field1 = "value" ...
    but have not yet tested...
    Only quitters quit!

Posting Permissions

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