numeric field between 0 and 1 causes Write Conflict error in Access

From: Joe Gilmour <joe(at)gilmours(dot)com(dot)au>
To: pgsql-odbc(at)postgresql(dot)org
Subject: numeric field between 0 and 1 causes Write Conflict error in Access
Date: 2015-06-25 05:07:42
Message-ID: 558B8C9E.9030100@gilmours.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

I have several tables with a numeric fields (15,2) in them. The client,
on Windows (MS Access 97 on XP, please don't hate me) will throw "Write
Conflict" errors on some records. The determining factor seems to be
decimal places especially on numbers between 0 and 1. If any of the
fields in the record have a number field with data between 0 and 1 then
the record cannot be updated through regular editing in the client. It
can be updated using an update query just not in datasheet view or
navigating through the records. In 09.03.0300 it works OK so it appears
to be something changed in 09.03.0400. I can't seem to find a way to
work around this other than to downgrade the ODBC version.

Using another client (LibreOffice) works no problem using the same DSN
so it's a combination of Access and the latest ODBC driver.

TIA

Joe

Browse pgsql-odbc by date

  From Date Subject
Next Message Heikki Linnakangas 2015-06-26 16:30:31 Re: next release
Previous Message Heikki Linnakangas 2015-06-23 13:52:36 Re: Minor fixes to Windows tests