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?