pg money -> msaccess currency

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: pg money -> msaccess currency
Date: 2005-12-13 12:19:07
Message-ID: dnme9v$17be$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there any way (maybe via the odbc driver) to get MSAccess to
translate the money data type to Currency with linked tables?

I have converted our database from Access to Postgresql, but we are
still using the access front end. The difference between an Access
number type and an access currency type, is the currency type looks like
currency to the users and when they edit the field it continues to look
like a currency. If you just use currency formatting, then it looks like
a currency, but when you click on it to edit, the formatting is removed.
The bothers the users who liked to copy and paste the currency value
into various documents.

I posted on the odbc list, but it seems like no one is there.

Browse pgsql-general by date

  From Date Subject
Next Message Maik Trömel 2005-12-13 12:20:45 UPDATE table .....
Previous Message Sim Zacks 2005-12-13 11:24:36 Re: pg_autovacuum