Re: problem updating from form

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?