Horton

Re: [INTERFACES] M$-Access'97 and TIMESTAMPs

jose' soares <sferac@bo.nettuno.it>

View thread
From: "Jose' Soares Da Silva" <sferac@bo.nettuno.it>
To: interfaces postgres <pgsql-interfaces@postgreSQL.org>
Cc: Byron Nikolaidis <byronn@insightdist.com>
Date: 1998-06-09T14:42:23Z
Lists: pgsql-hackers 
On Tue, 9 Jun 1998, Jose' Soares Da Silva wrote:

> Hi, all!
> 
> I created a table with a TIMESTAMP data type to use with M$-Access, because
> Access uses such field to control concurrent access on records.
> But I have a problem M$-Access doesn't recognize a TIMESTAMP type, it see
> such fields as "text" instead of "date/time".
> Is there a way to make Access recognize TIMESTAMPs ?
>                                                            Thanks, Jose'
Also the following types are recognized as text:
       int28
       oid8
       oidint2
       oidint4

I forgot to say that I'm using :
       PostgreSQL-6.3.2
       Linyx ELF 2.0.33
       psqlodbc-06.30.0243
       M$-Access97
                                                            Ciao, Jose'