Re: ACCESS2k -> postgres via ODBC

On Tue, 8 May 2001, Steve O'Hagan wrote:

> 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.

There's a FAQ about PostgreSQL + Access at odbc.postgresql.org.

Re: your specific problem: for this subtable, what kind of field are
you using as the linking field?

--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington