Yes/no checkbox problem in ADP

[Steve Jensen]

I have an application (ADP) that is using a SQL Server 2005 database in 2000
compatibility mode. The ADP is compiled in Access 2000. When running the
application with Access 2003, there is a problem with bound yes/no fields on
forms using a checkbox. If you change the value (check the box for
instance), you cannot uncheck it (or vice versa) unless you navigate away
from the record and go back into it.

If you run the application with Access 2000 this problem does not occur.

 

[Sylvain Lafontaine]

Maybe: http://support.microsoft.com/kb/945674

BTW, the official newsgroup for ADP is m.p.access.adp.sqlserver.

 

[Steve Jensen]

Thanks, I went to that forum and found the solution - apparently a bug
introduced in SP3. The link to the hotfix:

http://support.microsoft.com/kb/943967/EN-US

Thanks again,
Steve

 

[Otto Mortensen]

I have an application (ADP) that is using a SQL Server 2005 database in
2000
compatibility mode. The ADP is compiled in Access 2000. When running the
application with Access 2003, there is a problem with bound yes/no fields
on
forms using a checkbox. If you change the value (check the box for
instance), you cannot uncheck it (or vice versa) unless you navigate away
from the record and go back into it.

If you run the application with Access 2000 this problem does not occur.

 

[Otto Mortensen]

I have an application (ADP) that is using a SQL Server 2005 database in
2000
compatibility mode. The ADP is compiled in Access 2000. When running the
application with Access 2003, there is a problem with bound yes/no fields
on
forms using a checkbox. If you change the value (check the box for
instance), you cannot uncheck it (or vice versa) unless you navigate away
from the record and go back into it.

If you run the application with Access 2000 this problem does not occur.