Com Interop problem Silverlight 4 and MS Access 2010

Question

I am trying to launch an existing MS Access database (Access 2010) from a Silverlight 4 OOB with elevated authorisation set. I keep getting an error. I can create a new Access application using the CreateObject keyword, but when I try to launch an existing one I get an error: "No object was found registered for specified ProgID."

Any help is appreciated. Here is the code I use:

string sMSAccess = "C:\\Users\\storltx\\Documents\\SL4Demo.accdb";
dynamic MSAccess = ComAutomationFactory.GetObject(sMSAccess);
MSAccess.Visible = true;

Answer 1

I think you should pass "Access.Application" string to GetObject call. like this:

dynamic MSAccess = ComAutomationFactory.GetObject("Access.Application"); 

Answer 2

OK, So how do I launch the Database from there? If I use dynamic MSAccess = ComAutomationFactory.GetObject("Access.Application"); I have a reference to Access but I still need to get a reference to the SL4Demo.accdb. In other words how do I continue the code?

Thanks!

:)=

Answer 3

Try your code like this:-

string sMSAccess = "C:\\Users\\storltx\\Documents\\SL4Demo.accdb";
dynamic app = ComAutomationFactory.CreateObject("Access.Application");
app .Visible = true;
app.OpenCurrentDatabase(sMSAccess);