DAO.CreateWorkspace() fails in Add-in with Excel 2007

We have a VBA Add-in component that we've used for a long time. Our users
have recently begun to report that the component no longer runs once they
install Office 2007.


We have always created an ODBC workspace as in the following:


DIM workODBC As DAO.Workspace

Set workODBC = CreateWorkspace("ODBCWorkspace", "Admin", "", dbUseODBC)



This call no longer succeeds.



To reproduce this, we set up a VISTA box, and installed Office 2007.



I have ran ComponentChecker and had it "Perform analysis of your machine
and automatically determine the release version".



Strangely, it reports back:



The following product releases were matched:



UNKNOWN



The file details show a number of UNKNOWN files:



MSADCOR.DLL

msado15.dll

msadomd.dll

....

....

....



Anyone seen this or have any ideas?



Thanks,



HS