When it comes to automation, MS Access Developers often have to decide between early or late binding, especially when referring to other MS Office applications.
The main reason is due to the multiple MS Access versions through the years, 97, 2000, 2003, 2007, 2010 etc. To ensure backward compatibility between versions, it is normally better to use late binding since early binding, could result in non-operation or system crashes because the Library reference made will fail.
This article will explained the difference between early and late binding to make the decision easier when doing custom software development.