Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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).

↑ Back to the top


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


Keywords: KB253177, kbfix, kbbug

↑ Back to the top

Article Info
Article ID : 253177
Revision : 1
Created on : 11/25/2002
Published on : 11/25/2002
Exists online : False
Views : 316