Hi
This is driving me mad, I'm hoping some one can help me. I have several
forms, each of which contain check boxes. The check boxes are based upon SQL
fields which have a bit data type.
Works fine on 95% of pcs. However, there are a few with a strange problem.
For certain users, ticking the box works fine. However, they cannot then
untick the box. If they exit the form, and then open the form again, the box
can be unticked. But only one box - must exit the form and then go back in
to untick another box.
So its like the record gets locked, then Save on the exit unlocks it. All
the effected PCs have the full Access 2003, on service pack 3.
Any ideas?
Thanks

There's a known bug in SP3 with SQL Server bit columns. Search Microsoft's
site for the hotfix.

"SimeonD" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi
> This is driving me mad, I'm hoping some one can help me. I have several
> forms, each of which contain check boxes. The check boxes are based upon
> SQL fields which have a bit data type.
> Works fine on 95% of pcs. However, there are a few with a strange problem.
> For certain users, ticking the box works fine. However, they cannot then
> untick the box. If they exit the form, and then open the form again, the
> box can be unticked. But only one box - must exit the form and then go
> back in to untick another box.
> So its like the record gets locked, then Save on the exit unlocks it. All
> the effected PCs have the full Access 2003, on service pack 3.
> Any ideas?
> Thanks
>
>

Hi Simeon,
I think that the following article is what bcap referred:
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
http://support.microsoft.com/kb/943967/EN-US

Please try installing the Access 2003 post-SP3 hotfix package to see if it
helps. If you have any other questions or concerns, please feel free to let
me know. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (E-Mail Removed).
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

Yep, that's it, cheers!

""Charles Wang [MSFT]"" <(E-Mail Removed)> wrote in message
news:NEgCY%(E-Mail Removed)...
> Hi Simeon,
> I think that the following article is what bcap referred:
> 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
> http://support.microsoft.com/kb/943967/EN-US
>
> Please try installing the Access 2003 post-SP3 hotfix package to see if it
> helps. If you have any other questions or concerns, please feel free to
> let
> me know. Have a nice day!
>
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ===========================================================
> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: (E-Mail Removed).
> ===========================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscripti...ult.aspx#notif
> ications.
>
> Note: The MSDN Managed Newsgroup support offering is for
> non-urgent issues where an initial response from the community
> or a Microsoft Support Engineer within 1 business day is acceptable.
> Please note that each follow up response may take approximately
> 2 business days as the support professional working with you may
> need further investigation to reach the most efficient resolution.
> The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by
> contacting Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscripti...t/default.aspx.
> ============================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> =========================================================
>

That great. Thanks Charles and bcap

""Charles Wang [MSFT]"" <(E-Mail Removed)> wrote in message
news:NEgCY%(E-Mail Removed)...
> Hi Simeon,
> I think that the following article is what bcap referred:
> 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
> http://support.microsoft.com/kb/943967/EN-US
>
> Please try installing the Access 2003 post-SP3 hotfix package to see if it
> helps. If you have any other questions or concerns, please feel free to
> let
> me know. Have a nice day!
>
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ===========================================================
> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: (E-Mail Removed).
> ===========================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscripti...ult.aspx#notif
> ications.
>
> Note: The MSDN Managed Newsgroup support offering is for
> non-urgent issues where an initial response from the community
> or a Microsoft Support Engineer within 1 business day is acceptable.
> Please note that each follow up response may take approximately
> 2 business days as the support professional working with you may
> need further investigation to reach the most efficient resolution.
> The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by
> contacting Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscripti...t/default.aspx.
> ============================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> =========================================================
>