this is not a question, just a heads up. I got a 'null not allowed' error message when trying to read a field from an Access db. This is how I got around it. The "On Error is trying to stop the program from bombing when it encounters the null. The receiving field has to be Variant because I get the error message if it is String:

Dim x As String
Dim y As Variant
...
On Error GoTo A
x = " "
y = rs("MTL")
If y <> Null Then
    x = CStr(y)
End If
A: On Error Resume Next