Problem with checkbox

Hi.

We are having a weird problem with the checkbox control.

We are using an access project (.adp) to connect to a SQL Server 2000 database and the visual basic editor that comes with Access to create the form, macros and reports that the system runs. We don't use third party tools and its purely just the default settings that MSAccess gives

We use checkboxes in the project forms linked to fields in our database to represent boolean fields in our tables. For that we simply put the ControlSource property to the proper field name.

Since yesterday the checkboxes in the project started to work funny: you could check the checkbox but you couldn't uncheck it, at best you where able to do it after pressing the space bar, clicking on it simply dosn't work, in the worst case you have to enter to the table to change the field value manually.

This happening for at least two differen projects running in two diferent SQL servers (we still have to check the others).

Does someone have an idea of what is the problem Im breaking my head with this.

Thanks.

I have the same problem - it is occurring for radio buttons, too. I am also using SQL SErver 2000 with an accesss project. What version of Access are you running

Yeah i have the same theory since this is not happening in all the computers just the ones that are automatically updated from the main corporate office. i will try to undo the updates before the date the error starting showing and see if that helps.

Thanks.

I have two systems running the same program - the one evidencing the problem s a Windows 2003 terminal server with Access 2003 sp3. The secod system has a copy of the same access project and the same SQL database, but it running Windows XP with Access 2003 sp3. I do not have the problem on this second machine.

The clients are running in Windows XP SP2 workstation, but the databases are really in SQL Server 2000 running in Windows Server 2003 SP1 servers which where updated a few days before we noticed the problem, i dont know if that could have something to do with it.

According to this:

http://www.utteraccess.com/forums/showflat.php Board=83&Number=1527109

you are right about the sp3, and Microsoft is aware of the issue. Now all we have to do is uninstall and reinstall Office to get back to SP2...

Thanks Sumerdai

I did what you said (unistall Office and install it again up to SP2) and the checkboxes worked again.
Now i justed have to figure out what to do when the next update is pushed to our computers from the main office

Actually, the fix has been released as of Dec 18th:

http://support.microsoft.com/kb/943967