Re: Timestamp column & Access linked ODBC table

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Timestamp column & Access linked ODBC table
Date: 2003-11-28 07:11:54
Message-ID: 3FC6F53A.A08E8A72@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Philippe Lang wrote:
>
> Hello,
>
> As soon as there is a timestamp column in a Postgresql table,
> it's impossible to update it through an Access ODBC link. I'm
> not the first one to face this problem, but does anyone have
> a definitive explanation, or maybe workaround?

Timestamp means timestamp(6) which Access couldn't handle
properly. Please use timestamp(0) instead.

regards,
Hiroshi Inoue

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Philippe Lang 2003-11-28 07:24:01 Re: Timestamp column & Access linked ODBC table
Previous Message Cristian Custodio 2003-11-27 17:43:17 Re: Character invalid saving memo with UpdateSQL