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.klaver@gmail.com