Re: problem updating from form

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 & then upon returning to the record the data reverts back to what
> existed in the field prior to the entry. These complaints have recently
> become more frequent. This is an 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. I can update the field successfully in the table
> in Access, but not in a form. I have isolated the table, removing any
> foreign keys from the table. There aren't any triggers. I created a
> new Access DB with only the table & a crude form with only two fields,
> the primary key & one other. In ODBC I made sure that row versioning
> was set as true and Text as LongVarChar was set as false. We have
> vacuumed, reindexed & performed a full vacuum on the Postgres DB
> multiple times. None of these actions have had a positive effect. I
> created an identical copy of the table & imported all of the data, over
> 194,000 records, into it. I saw the same problem results until I
> removed all, but about 20 records. Only then was I able to get the
> update from a form to stick on our test record.
>

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?

>
> Thank you,
> Karen

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