allow the user to choose the currency he wants for a data base

[Guest]

not allowing a international company to choose the currency for the data base
renders access unusable for most applications

 

[Graham R Seach]

Gee, and all this time I thought currency was determined by your Regional
settings!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Ed Warren]

The currency type is set in the regional settings ($,£ ,¥, etc). However,
access really does not understand 'currency' it just stores it as a floating
point number (xx.yy....). So if you need for people in different locales to
share currency data you will have to either decide on a 'coin of the realm"
everyone uses or build a data structure that stores at least a number
(15.00) and a currency type (dollar, pound, euro, yen) in the database then
a currency conversion routine to present it to the local user.

Ed Warren

 

[Rick Brandt]

Gee, and all this time I thought currency was determined by your
Regional settings!

Regards,
Graham R Seach
Microsoft Access MVP

That can't be right. If I create a database with a date field and a currency
field and enter January 15, 2005 and 150 dollars respectively and my regional
settings cause them to be displayed as...

1-15-2005 $150.00

....and I send that database to a user in the UK his regional settings will
likely cause the date to be displayed differently...

15-1-2005

While it looks different, this is still the same date. His regional settings
should NOT cause the currency value to display as 150 pounds because that is not
the same value as 150 dollars.

I was under the impression that once set in the database that the currency
format is "fixed" to avoid just this issue. Is that not the case?

 

[Ed Warren]

Can't say anything about sending $ to the UK but when my clients in the UK
enter £10, and they ship the databases to me in the U.S. I see $10.00. I
strongly suspect it works the same the other way around. I have to control
the presentation by forcing the use of £ in the format string
£###,###.##

Ed Warren

 

[Graham R Seach]

The OP's original issue was complaining about not being able to *choose* the
currency. I took that to mean *at each locale*.

There's no point complaining that Access can't convert currency from one
format to another, because no other database will do that either.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------