Posted on 2011-09-13
I am writing an access front end that will write some data to a SQL Server 2005 db. In turn our IT folks will then be doing something further with the data. I received a note from them that said make sure no 'NULL' values are written to the tables. I have never worried about this with Access back ends (though maybe I should have been...)
In any event, can someone help me understand why it is important, and how should I save a field if the user has entered no data....? Something like nz(txt1),"") maybe?