Bug #20300 Access Form

• Submitted: 6 Jun 2006 17:19
• Modified: 7 Jun 2006 12:59
• Reporter: [ name withheld ]
• Status: Not a Bug
• Category: Connector / ODBC
• Severity: S3 (Non-critical)
• Version: 5.51.12
• OS: Windows (Windows XP)
• CPU Architecture: Any

[6 Jun 2006 17:19] [ name withheld ]

Description:
Connecting through ODBC to Mysql, i ran into a problem. Doing so through Microsoft Access Form, a checkbox (whose Control Source is a 0/1 mysql field) will send mysql over odbc a value of -1 for 'checked' messing up your values or not even inserting them if you have a unsigned INTEGER field as I do for my field (where in the database 0=unchecked/1=checked). i assume this is a bug fix for mysql obbc. or is this the Microsoft JET database engines fault?

How to repeat:
setup a linked table to mysql database in Access. make sure that table has just 1 and 0 values which i assume is one of major ways to store checkboxes (or 'Y', 'N') in database.
make a form in Access, go into Design View, drag a checkbox onto form. right click on it and goto properties. goto Data tab. for Control Source choose the field of the table that has the 0/1's.

[6 Jun 2006 17:20] [ name withheld ]

maybe its not all that serious

[7 Jun 2006 12:59] Tonci Grgin

Hi. This is actually request for help in programming. Bug system is not appropriate place for this!
See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vadatBoolean.a...