Skip site navigation (1) Skip section navigation (2)

Access 97 and datatypes

From: Michael Davis <michael(dot)davis(at)prevuenet(dot)com>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Access 97 and datatypes
Date: 1999-02-14 00:06:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
I have several fields defined as the currency data type in Access 97.  When
I converted my Access 97 databases to Postgress, I used the Money data type.
When I update a money field from Access 97, I get an error "wrong type".  I
finally had to change data type from money to double to get Access to
properly communicate with these fields.  I am also having trouble with
boolean fields.  The are view differently in Postgress and Access.  Has any
one work encounter and/or created a work around these issues?
ODBC Driver version: PostreSQL 6.40.0004
Postgres SQL version: 6.4.2

Thanks, Michael

pgsql-interfaces by date

Next:From: Michael DavisDate: 1999-02-14 00:09:53
Subject: RE: [INTERFACES] (libpq question) Holy cow, what's all this fluff?!
Previous:From: Karsten KausDate: 1999-02-13 23:58:53
Subject: Re: [INTERFACES] ODBC - MSysConf

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group