User sometimes gets the following error when browsing Web Suite. The error occurs when browsing the main application or the admin options.
Could not load file or assembly 'Microsoft.Office.interop.access.dao' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
This usually happens if the computer running Web Suite has Microsoft Office products installed and you can fix it by following these steps:
1. Open Notepad (Run as Administrator) and edit the web.config files of Web Suite in the following locations:
C:\Program Files (x86)\BillQuick Web Suite\Web Suite 20XX\public
C:\Program Files (x86)\BillQuick Web Suite\Web Suite 20XX\admin
2. Add the following markup into each of the web.config files right after the <configuration> tag at the beginning:
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity publicKeyToken="71e9bce111e9429c" name="Microsoft.Office.Interop.Access.Dao" culture="neutral">
</assemblyIdentity>
<publisherPolicy apply="no" />
</dependentAssembly>
</assemblyBinding>
</runtime>
3. Save the changes.
You can also watch this video:
This should resolve the issue and prevent it from recurring.