Re: problem updating from form

Karen Springer <karen.springer@xxxxxxxxxx> · Mon, 03 Jan 2011 00:12:25 -0700



    Hi Adrian,

    
    Yes, the complaints have increased with the number or rows and the
    number of users accessing the DB.

    
    The problem record looks like this.

    
    BarCode:  W205179

    PartNumber:   380-013  

    LRU:  380-013   

    PartsListRev    

    SerialNumber    

    MTN    

    DocNum:  150-2380-XXX

    Comments    

    SupplierNo    

    DrawingNoRev    

    WorkOrder    

    BldStdRev:  1.02  

    Quantity    

    Salesorder    

    WOQuantity:  1   

    xmin:  1933434795

    
    There is nothing that stands out with the data.  I have been trying
    to update the WorkOrder field in my tests.  The users complain that
    they have problems updating the WorkOrder,  MTN & Comments
    fields.  This particular record has consistently had a problem
    (though not always), but users are unable to update other records as
    well.  It doesn't occur with all records though.  Most of the time
    the updates work fine.  I test using a new Access DB that contains
    only a copy of this table and a form with the BarCode and WorkOrder
    fields.  There isn't any code behind the form. 

    
    Best regards,

    Karen

                                                              
    On 01/02/2011 12:22 PM, Adrian Klaver wrote:
    

      A couple of questions.
1) Has the increase in complaints tracked an increase in number of rows in the 
table?
2) Could we see the problem record or is it possible say how it differs from the 
other records?


      Paul Malinowski