dlugirapfr
Registered User.
- Local time
- Today, 06:46
- Joined
- Nov 22, 2012
- Messages
- 68
Hi all,
I have big problem with connection between ODBC and Access 2007. Everything is linked correctly but I have problem with separator in decimal field.
In my country this separator is "," not ".". I found information about connection in MSysObjects.connect table that
I found somewhere that I need to change NUM value from NLS (default) to MS. Do you know how to edit this value?
For example Access 2007 see value "123.8" (so it is in my country "123,8" ) like "1238"
Thanks for any idea how to edit this field connection. I cannot find answer anywhere.
I have big problem with connection between ODBC and Access 2007. Everything is linked correctly but I have problem with separator in decimal field.
In my country this separator is "," not ".". I found information about connection in MSysObjects.connect table that
Code:
...;BTD=F;BNF=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;...
For example Access 2007 see value "123.8" (so it is in my country "123,8" ) like "1238"
Thanks for any idea how to edit this field connection. I cannot find answer anywhere.