Just prior to the .Close statement, find out what the object is. Either Debug.Print TypeName(objConnection) or MsgBox TypeName(objConnection).
If the value is equal to "Nothing", then the object has not been set to anything, and youâll need to track that down..
|