Access 97 and datatypes - Mailing list pgsql-interfaces

From Michael Davis
Subject Access 97 and datatypes
Date
Msg-id 93C04F1F5173D211A27900105AA8FCFC028189@lambic.prevuenet.com
Whole thread Raw
List 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:

Previous
From: Taral
Date:
Subject: Re: [INTERFACES] (libpq question) Holy cow, what's all this fluff?!
Next
From: Michael Davis
Date:
Subject: RE: [INTERFACES] (libpq question) Holy cow, what's all this fluff ?!