Regional settings and data returned from Access

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?

"Jeff J Jones" <jjones#NOSPAM#@jonestc.com> wrote in message <news:Osi6Pyl8DHA.1640@TK2MSFTNGP11.phx.gbl>...

 > 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?

Try using parameterized QueryDef objects to sidestep string conversions.
Otherwise, use Str$ when embedding numbers and Format$ with date/times.

--
Joe Foster <mailto:jlfoster%40znet.com> DC8s in Spaace: <http://www.xenu.net/>
WARNING: I cannot be held responsible for the above They're coming to
because my cats have apparently learned to type. take me away, ha ha!<!-- ~MESSAGE_AFTER~ -->