ACC2000: Column with Data Type of Bit Does Not Allow Null Value in Access Project

View products that this article applies to.

This article was previously published under Q253177

Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

Expand all | Collapse all

SYMPTOMS

In a Microsoft Access project, if you create a field in a table and set the field's data type to Bit, you cannot click to select the AllowNulls property check box.

Back to the top

RESOLUTION

To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 (http://support.microsoft.com/kb/245025/EN-US/ ) OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

Back to the top