Regional settings and data returned from Access

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jeff J Jones (jjones#NOSPAM#_at_jonestc.com)
Date: 02/13/04 

Date: Fri, 13 Feb 2004 11:09:43 -0700

I have a VB application which utilizes an Access 2000 database.

It works fine when the user's Language/Regional setting is "English (US)".
But, change the Lang/Reg to "French (Canadian)" and a typical fraction that
would have returned as "3.14" is returned as "3,14".

Notice the comma instead of the period for the decimal separator. So If I
try to use this number in any SQL string - of course it bombs.

How do I solve this please?

Relevant Pages

  • Changing Language/Region settings causes data returned from Access to change.
    ... I have a VB application which utilizes an Access 2000 database. ... It works fine when the user's Language/Regional setting is "English ". ... change the Lang/Reg to "French " and a typical fraction that ...
    (microsoft.public.vb.general.discussion)
  • Re: Table relationships, what am I missing?
    ... Your main form will be able to display a selected word and its English ... with the basic logic of the table relationships in my Access database. ... English translation and - crucially - my own cross references to other ... OppositeMeaning - being words with the opposite meaning. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: [opensuse] SuSE removes files
    ... Tellico databases of music. ... I would like to express myself in Spanish, ... because my English is bad. ... Tellico is an application for KDE managing CD or books, in a "database ...
    (SuSE)
  • Re: Run a function from "On Click" or "On Exit"
    ... If nothing is visible, try compacting the database: ... The expression "On Exit" you entered as the event property setting ... the following error: Ambiguous name detected: English ... *The expression may not result in the name of a macro, ...
    (comp.databases.ms-access)
  • Re: localization question
    ... For example, the database was ... desinged in English but is to support French and German speaking users. ... English captions for the desired ones. ... id, caption, localizedcaption ...
    (microsoft.public.dotnet.languages.vb)