title: Reference Microsoft.Office.interop.access.dao.dll cause error C#
body: <p>I have an application which connect to access 2003.
  I'm facing a problem with insert bulk of rows to access, so i came to an solution by using DAO (Microsoft.Office.interop.access.dao.dll) to improve performance of this process as follow this link
  <a href="https://stackoverflow.com/questions/1036856/retrieving-the-com-class-factory-for-component-with-clsid-xxxx-failed-due-to-t">Retrieving the COM class factory for component with CLSID {XXXX} failed due to the following error: 80040154</a></p>
  <p>But when i open the connect to access by using</p>
  <blockquote>
  <p>using DAO =Microsoft.Office.interop.access.dao.dll;
  ....</p>
  <p>new DAO.DBEngine();</p>
  </blockquote>
  <p>this line gave me an error:</p>
  <blockquote>
  <p>System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419} failed due to the following error: 80040154</p>
  </blockquote>
  <p>My application is 32 bit and i running the program in a machine with Win xp 32 bit too, It work fine until i start using DAO</p>
  <p>I have try many thing that i came up when google, but nothing help, like this:
  <a href="https://stackoverflow.com/questions/12138901/error-in-create-access-database">Error in create access database?</a></p>
  <p>--
  More info:
  After install</p>
  <blockquote>
  <p>AccessDatabaseEngine.exe
  <strong>the problem go away</strong>, so i think it must be something like the dll can't register, and then after install the package, somehow it's registered DAO dll.</p>
  </blockquote>
  <p>But i can't not install anything in production server, <strong>so i need a way to manual register the dll</strong>, or something like that, to let the application work without install <strong>AccessDatabaseEngine.exe</strong> package</p>
  <p>Please give me any advice</p>