Re: ACCESS2k -> postgres via ODBC

From: "Steve O'Hagan" <sohagan(at)dont-spam-me-stanger(dot)com(dot)hk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ACCESS2k -> postgres via ODBC
Date: 2001-05-08 03:36:47
Message-ID: 9d7p3k$n6j50@imsp212.netvigator.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've since discovered that *any* operation on the subtable gives the same
type of error message, i.e. it doesn't need to be associated with a
form-subform pair, even browsing the table directly from the ACCESS linked
table and trying to edit a record gives this result. The sub-table in
question has a number of boolean fields, I'm wondering if it's the ACCESS
boolean -> postgres boolean translation which is causing the problem. Other
tables seem to be working OK via ACCESS. In the ODBC driver, the 'boolean as
char' option is checked.

Regards,
SGO.

"Steve O'Hagan" <sohagan(at)dont-spam-me-stanger(dot)com(dot)hk> wrote in message
news:9d58ug$m4b97(at)imsp212(dot)netvigator(dot)com(dot)(dot)(dot)
> I have an ACCESS 2000 form with subform linked via ODBC to postgres
> 7.1 table and sub-table. If I open the form, then edit data in the
subform,
> everything is OK. However, if I change the main form's record either using
> a search or simply using record navigation keys, both the form and subform
> show the correct table and subtable data, BUT ACCESS 2000 will not
> allow me to edit any data in the subform. The error message is that
> "the data has been changed by another user". This is nonsense, since I'm
> the only user using the database!! Doing 'refresh records' does not help.
>
> Additionally, does anybody have a descriptions of the various options in
the
> postgres ODBC driver setup, or better, recomended setting for ACCESS
> 2000 as front-end for a postgres database.
>
> Any ideas?
>
> Regards,
> SGO.
>
>
>
>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Clark L. Naldoza 2001-05-08 04:06:50 Re: Re: PostgreSQL - PHP insert deleted from database immediately?
Previous Message Tom Lane 2001-05-08 02:48:04 Re: poor performance on 7.1 vs 7.0