Detecting DAO and it's version
Posted on 2002-05-15
Let me start off by telling you what I'm trying to do. I'm writing a component checker to detect if a component is installed and what it's version is. I'm detecting things like ADO, DTS, DMO, and DAO. I'm trying to do this with out setting any project references, so yes I'm using late binding. Please save the lecture of the evils of late binding, I already know. This program is not doing much other than provide me with a users system info, to try and make my life easier when the call up complaining that something doesn't work because they didn't read the release notes and didn't follow instructions about installing components. I digress...
The one that's giving me the biggest problem is DAO. The following is an example piece of code:
Set lTemp = CreateObject("DAO.Recordset")
All the other have not given me any problem. I really don't want to go looking for files on their hard drive either.
Any have an idea on how to detect DAO and report it's version using a late binding method?