I'm writing to an Access db using ado under VC6 and I need to update a field. I need to determine the field's variant type before setting the field (or else ADO will cause an exception). I'm guessing this information might come from the OpenSchema call in Recordset. This is where I'm getting the table and column names. If someone could give a quick example it would be helpful (It could even be from another language since the calls would be similar).