I've got an Access Project (ADP) with a SQL Server 2000 back-end that has
been running fine for years. Since installing SP3 the following is happening:
- In an Access form I can check a checkbox that is based on a bit field but
I cannot uncheck it. Once it is checked it remains checked.
- When editing the corresponding table from Access, I get the same behavior:
I can overtype true with false (or 0) but I can't store it; as soon as I try
to save the record or select another record it switches back to true.
- The default value of the field in SQL Server is set to 0; however when I
add a new record in Access, the field defaults to true...
(I can change the field value by using SQL Server Enterprise Manager.)
Any suggestions?
Thank you,
Renee
Ken Snell (MVP) - 28 Sep 2007 20:24 GMT
It's a bug that has been introduced by 2003 SP3. MS is aware of it.

Signature
Ken Snell
<MS ACCESS MVP>
> I've got an Access Project (ADP) with a SQL Server 2000 back-end that has
> been running fine for years. Since installing SP3 the following is
[quoted text clipped - 19 lines]
>
> Renee