Certain fields not updatable

From: Heewa (Heewa_at_discussions.microsoft.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 07:34:02 -0700

I'm using ADO in VB 6.0 to read and update from an Access Database. There are certain fields in certain records that are Null sometimes (not on all records). If the field has a value (even empty string: ""), then it's updatable. I can change the value and everything is fine.

If, however, the value is Null, then it's not. The 'adFldUpdatable' flag is not set for that field's 'Attribute' property, and I can't set it while the recordset is open. Keep in mind that this is the same field, it varies from record to record. Before you say it, I'm not going to change the database so it holds no Nulls.