.NET Access automation with Access 2007 Runtime
- by Robert Morgan
I'm having trouble deploying .NET application which uses Microsoft Access automation.
I've installed the Access 2007 Runtime and Primary Interop Assemblies (PIAs) on the target machine:
Access 2007 Runtime
Office 2007 PIAs
However, when I try to create the ApplicationClass:
Application access = new ApplicationClass();
I get the following exception:
Unhandled Exception: System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {73A4C9C1-D68D-11D0-98BF-00A0C90DC8D9} failed due to the following error: 80080005.
I've googled the error code and tried tweaking the security settings in dcomcnfg, to no avail.
Any ideas?
I don't want to install the full version of Access due to the cost, and the runtime should at least be able to create an instance of the application, surely?