Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
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 |
| Last Review | : | December 31, 2007 |
| Revision | : | 3.0 |
On This Page
SYMPTOMS
Consider the following scenario:
| • | You have a computer that is running Microsoft Office Access 2003. |
| • | You install Microsoft Office 2003 Service Pack 3 (SP3). |
| • | You create an Access 2003 project that links to a table in Microsoft SQL Server. |
| • | The table in SQL Server has a Bit data type column. |
In this scenario, you encounter one of the following symptoms in Access 2003.
Back to the top
Symptom 1
When 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."
Back to the top
Symptom 2
After 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.
Back to the top
RESOLUTION
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:
945674 (http://kbalertz.com/Feedback.aspx?kbNumber=945674/)
Description of the Access 2003 post-Service Pack 3 hotfix package: December 18, 2007
Back to the top
WORKAROUND
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:
| • | Click to select the check box, and then press SPACEBAR to change the value. |
However, this method does not always work.
Back to the top
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top
APPLIES TO
| • | Microsoft Office Access 2003, when used with: |
| | | Microsoft Office 2003 Service Pack 3 |
|
Back to the top
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please