title: Access XP (2002) ADP as a client to SQL Server 2005 crashes on click on a bound Checkbox
body: <p>for a Client we have to use a pretty old-fashioned Version of MS Access (2002 XP). </p>
  
  <p>Now I have the following problem: On a continouus subform bound to a Recordset with a table on my SQL Server 2005 the whole MS Access application crashes whenever someone clicks on a bound Checkbox. The bound field on the SQL Server is of datatype bit. </p>
  
  <p>I googled this issue and found that Access XP is not able to handle the difference between SQL Server  (1 = True and 0 = False) and Access (-1 = True and 0 = False) on Boolean-Values. Thus I should switch the datatype to tinyint because of this bug in Access XP. However this does not solve my problem. The application still crashes. Has someone found a solution to get a bound checkbox running in Access XP ADPs?</p>