Solution#2
Access Object Collector error: Database
Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngineClass' to interface type 'Microsoft.Office.Interop.Access.Dao._DBEngine'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{00000021-0000-0010-8000-00AA006D2EA4}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
At first I thought this could be issue due to corrupted files for Management Studio, so to overcome that conclusion I have tried from another client's machine which has been successful to load the database properties with no error/warnings. So the conclusion is some issue with system files on the machine which is presented with same error, the issue could be with the DLL file 'DAO360.DLL'. Also to take out what are the recent changes to this machine I found that SQL Server Migration Assistant was installed recently and to solve the COM component error we could try re-register of specified DLL file above by using:
- Click Start, and the click Run.
- Type the following command: Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"
Once it is completed it will prompt a command box stating, specified DLL registered successfully. So to see whether this has solve the actual prblen I have tried accessing the same database from SSMS, to some extent the error on subject line was not presented again bu with this error: An error occurred while loading database content
As a final trial before I decide on format the machine and reload the required tools again, I tried to check whether the PATH environment varialble is directed to correct location and to check this the procedure will be the following:
1. Right click properties on My Computer
2. Go to the tab “Advanced”
3. Click on the button “Environment Variables”
4. On the System Variables section, look for the variable “Path” and click on it.
5. Once highlighted, click the “Edit” button.
6. Go to the end of the “Variable value” , add a semicolon and then add the path of the DAO360.dll.
7. Click OK button
8. Click OK button
9. Click OK button
