Re: problem updating from form

On Sunday 02 January 2011 11:12:25 pm Karen Springer wrote:
> 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

I agree nothing really stands out. I think you will find more information, as
you suggested in another post, on the psqlodbc list. If you do that, might I
suggest giving the full configuration for the ODBC connection.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com