DAO/ADO/Access97/Access2000 and NULLS!!!! (Information only)
Posted on 2001-06-22
another quick question conserning DAO and ADO connected to a MS Access 2000 DB
Using DAO and setting text boxes up with whatever data is in the fields from a recordset is fine.
Using ADO however causes an invalid use of null error when setting the exact same record to the text boxes.
Why is this?, does this mean that I need to check each record for the existence of nulls before setting the
text boxes?, which is what Im doing now (pain in the butt!)
quick thought : Ive also converted from Access97 to Access2000, Could this be the difference? and not DAO/ADO?