G
Guest
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
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