Re: [GENERAL] problem updating from form

2011-01-03 Thread Vincent Veyron
Le dimanche 02 janvier 2011 à 01:31 -0700, Karen Springer a écrit : > We are using PostgreSQL 8.1.4 on Red Hat, Microsoft Access 2002 That is one of the worst versions of Access ever. Lots of bugs. Do try an other version (2K, 2003 are much better) and see if the problem persists. -- Vincent

Re: [GENERAL] problem updating from form

2011-01-03 Thread Adrian Klaver
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 >

Re: [GENERAL] problem updating from form

2011-01-03 Thread Jeremy Harris
On 2011-01-03 06:29, Karen Springer wrote: We are running RHEL 4.1 which is why the newer version did not install with RHEL. RHEL 4.1 should be offering pgsql 8.1.15 in the apps channel (Red Hat Application Stack v1). - Jeremy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.

Re: [GENERAL] problem updating from form

2011-01-02 Thread Alban Hertroys
On 3 Jan 2011, at 8:12, Karen Springer wrote: > 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 Acce

Re: [GENERAL] problem updating from form

2011-01-02 Thread Karen Springer
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 WorkOr

Re: [GENERAL] problem updating from form

2011-01-02 Thread Karen Springer
Hi Tom, Due to the responses I received, I am now thoroughly convinced of the need to upgrade & have passed this information on. We are running RHEL 4.1 which is why the newer version did not install with RHEL. I initially was using an older version of psqlodbc, but decided to upgrade to th

Re: [GENERAL] problem updating from form

2011-01-02 Thread Adrian Klaver
On Sunday 02 January 2011 12:31:43 am Karen Springer wrote: > Hi, > > I have a problem that has me stumped. We have a table that is the main > table in a production Microsoft Access application. Our users are > complaining that sometimes they enter data in the form, move off of the > record & the

Re: [GENERAL] problem updating from form

2011-01-02 Thread Tom Lane
Karen Springer writes: > I have a problem that has me stumped. We have a table that is the main > table in a production Microsoft Access application. Our users are > complaining that sometimes they enter data in the form, move off of the > record & then upon returning to the record the data r

Re: [GENERAL] problem updating from form

2011-01-02 Thread Jeremy Harris
On 2011-01-02 08:31, Karen Springer wrote: We are using PostgreSQL 8.1.4 on Red Hat, Microsoft Access 2002 & psqlodbc_09_00_0200. You don't say which RedHat. RHN offers 8.1.22 for RHEL5 currently.Are you not running regular updates? - Jeremy -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] problem updating from form

2011-01-02 Thread Harald Armin Massa
Hello Karen, intermittent problem, but I have been able to replicate the issue > consistently on one particular record. We are using PostgreSQL 8.1.4 on Red > Hat, Microsoft Access 2002 & psqlodbc_09_00_0200. > PostgreSQL 8.1 was EndOfLifed in November 2010, you are recommended to plan for an up

[GENERAL] problem updating from form

2011-01-02 Thread Karen Springer
Hi, I have a problem that has me stumped. We have a table that is the main table in a production Microsoft Access application. Our users are complaining that sometimes they enter data in the form, move off of the record & then upon returning to the record the data reverts back to what exist