Bug #27755 SELECT IsNull(field) yields True for NOT NULL column (MS Access)
Submitted: 11 Apr 2007 12:40 Modified: 15 Apr 2007 12:54
Reporter: stefan hoffmann Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.51.14.00 OS:Windows
Assigned to: CPU Architecture:Any

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[11 Apr 2007 20:07] Miguel Solorzano
IsNull Test on Access

Attachment: isnull.png (image/x-png, text), 48.39 KiB.

[12 Apr 2007 10:12] stefan hoffmann
design view in Access

Attachment: query_designview.JPG (image/jpeg, text), 46.28 KiB.

[12 Apr 2007 10:12] stefan hoffmann
result in Access

Attachment: query_result.JPG (image/jpeg, text), 21.23 KiB.

[12 Apr 2007 10:12] stefan hoffmann
data in MySQL query browser

Attachment: query_browser.JPG (image/jpeg, text), 29.26 KiB.