Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / September 2007

Tip: Looking for answers? Try searching our database.

Bit field problems after installing A2003 SP3

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Merlinus - 28 Sep 2007 19:13 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.