Hello List Members,
we have a simple SQL-Table:
one autoincrement field ID as primary key
one field value of type float
If we connect to the table via Access (Access97 or Access2000) and want to change a
value (in our case to the value 9,7 ) Access changes the display from 9,7 to
9,69999999999. If we modify this value and want to update the table a message is shown
that tells us that Access has detected in 'internal' modification of the field and our
changes are not accepted.
What can we do ?
Best Regards,
Dirk Datzert
Rasselstein Hoesch GmbH
Informatik / Anwendungsentwicklung
Koblenzer Strasse 141
D-56626 Andernach
Tel.: +49 (0) 2631 81-4595
Fax.: +49 (0) 2631 81-15-4595
Mail: [EMAIL PROTECTED]
URL: http://www.rasselstein-hoesch.de
BEGIN:VCARD
VERSION:2.1
N:Datzert;Dirk
FN:Dirk Datzert
ORG:Rasselstein Hoesch GmbH;Andernach
TEL;WORK;FAX:+49 2631 81 15 4595
ADR;WORK:;+49 2631 81 4595;Koblenzer Str. 141;Andernach;Rheinland-Pfalz;56626;Germany
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:+49 2631 81 4595=0D=0AKoblenzer Str. 141=0D=0AAndernach, Rheinland-Pfalz 566=
26=0D=0AGermany
URL;WORK:http://www.rasselstein-hoesch.de
KEY;X509;ENCODING=BASE64:
MIIDVTCCAr6gAwIBAgIPAM2aAAAAAkJs9V5JP7ynMA0GCSqGSIb3DQEBBAUAMIG8MQswCQYD
VQQGEwJERTEQMA4GA1UECBMHSGFtYnVyZzEQMA4GA1UEBxMHSGFtYnVyZzE6MDgGA1UEChMx
VEMgVHJ1c3RDZW50ZXIgZm9yIFNlY3VyaXR5IGluIERhdGEgTmV0d29ya3MgR21iSDEiMCAG
A1UECxMZVEMgVHJ1c3RDZW50ZXIgQ2xhc3MgMSBDQTEpMCcGCSqGSIb3DQEJARYaY2VydGlm
aWNhdGVAdHJ1c3RjZW50ZXIuZGUwHhcNMDExMTEyMTIwMTM1WhcNMDMwMTAyMTIwMTM1WjBp
MQswCQYDVQQGEwJERTEQMA4GA1UEBxMHTmV1d2llZDEVMBMGA1UEAxMMRGlyayBEYXR6ZXJ0
MTEwLwYJKoZIhvcNAQkBFiJEaXJrLkRhdHplcnRAcmFzc2Vsc3RlaW4taG9lc2NoLmRlMIGf
MA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCog/5TyCRdMjACIM/U23qq0n0LUEeb+X3WpIn5
2UHosqQMDdLDEtlUOMSKTrqcsp3lHTOQWwj65/T3cI85brb7PkJDtbCI57MVTtMIKByd946g
uIOe6xti0H+lJAscIO1a6FqFjjJLhudWpDqaWgW95qGaFVT1me2xPEaoiampxQIDAQABo4Gq
MIGnMDMGCWCGSAGG+EIBCAQmFiRodHRwOi8vd3d3LnRydXN0Y2VudGVyLmRlL2d1aWRlbGlu
ZXMwEQYJYIZIAYb4QgEBBAQDAgWgMF0GCWCGSAGG+EIBAwRQFk5odHRwczovL3d3dy50cnVz
dGNlbnRlci5kZS9jZ2ktYmluL2NoZWNrLXJldi5jZ2kvQ0Q5QTAwMDAwMDAyNDI2Q0Y1NUU0
OTNGQkNBNz8wDQYJKoZIhvcNAQEEBQADgYEAOHB5sq4AdTAwizcmGPgdnfPo9btBu1d/PRNO
D/xoIhXlI4A0ehRZCBGuOup0L78YBj+DZUMDOK3H6+5M8rOfCazkcYlcfdxZ9LeNRkMy+RRx
PbmXelKB7UjM6IfJyZiQzm/jTwxFle3L+W8TMSPwmAdTJOo0YkikHCAlxNLMn4y=
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20030701T072156Z
END:VCARD
