HandelIT
asked on
MS Access 2003 Add and Edit forms with a check box cannot uncheck the box after checked
We have a MS Access 2003 program that for some reason with this one machine running Windows 2000 once the user checks a check box on either an add or edit form the user cannot uncheck the box and likewise if they open the edit form and the check box was already checked they cannot uncheck the box. The program is using a MS SQL 2000 server as the back end for this. I'm not really sure how else to explain this any better than that. Thanks in advance for your assistance with this.
Can you get the user to try this at table level?
Is there any code on the checkbox that is being called?
Is the field linked to a SQL Server BIT field, does the BIT field have a default value of 0
Do you get an error message?
Can you try and set the value in code?
Cheers, Andrew
Is there any code on the checkbox that is being called?
Is the field linked to a SQL Server BIT field, does the BIT field have a default value of 0
Do you get an error message?
Can you try and set the value in code?
Cheers, Andrew
ASKER
Hey Andrew,
This user does not have direct access to the SQL database and they are running on a Novel System so the SQL server is running with SQL Server Authentication. The fields that are trying to be set are bit fields with no default values. No error message is returned whatsoever. Unfortunately with the way this machine is setup I can't really change the code but I can confirm that with other machines I am able to change the value of the bit field with no problems whatsoever. This appears to be a problem specifically with this one machine which is very, very strange.
This user does not have direct access to the SQL database and they are running on a Novel System so the SQL server is running with SQL Server Authentication. The fields that are trying to be set are bit fields with no default values. No error message is returned whatsoever. Unfortunately with the way this machine is setup I can't really change the code but I can confirm that with other machines I am able to change the value of the bit field with no problems whatsoever. This appears to be a problem specifically with this one machine which is very, very strange.
If this was MDB rather than ADP then I would be looking at the ODBC drivers not sure though with ADP.
Cheers, Andrew
Cheers, Andrew
Oh and certainly client configuration rather than Access
Cheers, Andrew
Cheers, Andrew
ASKER
Yeah the problem was that we updated the code and the references changed. The user was using Office 2K but then they had a problem after we updated the code with references and the user had to update to Office 2K3. After they updated their Office is when we started to have this mysterious problem with the check boxes.
ASKER
Ok I am now able to replicate this problem on a terminal server of the customers as well. So any tips I will be able to try out directly if anyone has any ideas.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the shared wisdom - you saved me many many hours of useless labor right there:) Note that a newer fix (kb-956722) has become available:
http://support.microsoft.com/kb/956722
Cheers,
zgilboa
http://support.microsoft.com/kb/956722
Cheers,
zgilboa
ASKER