Re: [ODBC] Views, Access 2000 and write conflicts

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Nick Haw <nick(dot)haw(at)operagrp(dot)com>
Cc: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [ODBC] Views, Access 2000 and write conflicts
Date: 2002-06-28 00:21:56
Message-ID: 3D1BAC24.F4F36B31@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-odbc

Nick Haw wrote:
>
> Hello all
>
> I am having a major problem with a view I have created. I want
> users to be able to access it in using a form in access 97 and
> update some of the underlying data. I created the view and using
> my ODBC connection I linked the view to the Access database.
> Below is the sql I used to create the view.

Is your server's version 7.2 ? If so, it's a known bug.
Please look at the thread in pgsql-general [Using views
and MS access via odbc] e.g.
http://archives.postgresql.org/pgsql-general/2002-05/msg00170.php.

regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruce Badger 2002-06-28 12:54:53 Frontend - Backend protocol change?
Previous Message CG 2002-06-27 15:00:22 pqxx::Connection("dbname=name");

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2002-06-28 05:40:12 Re: [ODBC] "Field is too small"
Previous Message pcross 2002-06-27 21:55:51 Problem with updates