Icon View Incident Report

Serious Serious
Reported By: Vinnie Murdico
Reported On: 9/19/2002
For: Version 3.17 Build 1
# 1231 Updating Tables with Null Boolean Fields or Time Fields Causes Update Conflict

On a small table (3 string fields), I was able to edit a field and update the record while viewing the table in datasheet mode in Access. However, on another table with many fields of various types, if I edited one of the fields (not a key field) and then tried to move to another record (thereby causing a save of the current record), Access would tell me that I was trying to save a record that was recently changed by another user and I could Drop Changes or Copy to Clipboard. A Save Changes button was visible but disabled so I couldn't even bypass the error message.

Comments Comments
The Boolean field issue is a problem with Access, which only supports True or False (not Null) as values for Boolean fields. In order to correct this you must make sure that the table has a default value of False set for all Boolean fields in tables that need to be updated from Access.

Resolution Resolution
Fixed Problem on 9/22/2002 in version 3.18 build 1