Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
After you install Office 2003 SP3, you encounter various problems in an Access project when you work with a Bit data type column in a linked SQL Server table
Article ID: 943967 - View products that this article applies to.
Consider the following scenario:
Symptom 1When you insert rows into the table by specifying the default value of 0 (zero) for the Bit data type column, the value for the column in the new row is 1. A value of 0 means "false." A value of 1 means "true."
Symptom 2After you add a check box for the current record to a form, and then you click to select the check box, you cannot click to clear the check box. This problem occurs if the check box is bound to the Bit data type column.
Note These problems occur only after you install Office 2003 SP3.
To resolve this problem, obtain the Access 2003 post-Service Pack 3 hotfix package that is dated December 18, 2007. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/945674/ )Description of the Access 2003 post-Service Pack 3 hotfix package: December 18, 2007
To work around the problem that is described in the "Symptom 2" section, move to a different record, and then move back to the record that you want to change. Then, you can typically click to clear the check box.
In some cases, you can also use the following method to clear the check box:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.