The information in this article applies to:
SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.
CAUSE
In Microsoft Access version 1.x, both the Microsoft Access user interface
(UI) and the Microsoft Jet database engine assume a default value of zero
for Boolean values. However, in Microsoft Access version 2.0, the Microsoft
Jet database engine assumes a default value of null for Boolean values,
while the UI still assumes a default value of zero. Thus, when no value is
entered in a Boolean field in an attached SQL table, the UI displays a zero
in the field, but a null is written by the Microsoft Jet database engine to
the attached table. Since the SQL table does not accept null values for
Boolean fields, you receive an error message.
RESOLUTION
To work around this problem, make sure that you either enter a non-zero
value in the Boolean field, or retype the zero to force the Microsoft Jet
database engine to write a zero to the SQL table rather than the default
null value.
STATUSMicrosoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access version 7.0. Additional query words: attaching sql server
Keywords : kbinterop OdbcSqlms OdbcOthr |
Last Reviewed: April 6, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |