Could not quit MSACCESS.EXE

[Ezhil]

Hi-

I am trying to create MS access file (.mdb) from the data set with the
following code. Every thing is working fine. But I found the MSACCESS.EXE is
still running in the Task Manager. When ever I run this program new
MSACCESS.EXE is added to task manager. I could not kill the process after I
created the file. I tried all the possible ways and checked with user forums,
news group and MSDN, but no luck. I would really appreciate if any body can
help.

Access.Application accessData;
accessData = new Access.ApplicationClass();
accessData.NewCurrentDatabase("C:\Test\Test.mdb");
accessData.ImportXML("C:\Test\Test.xml",Access.AcImportXMLOption.acStructureAndData);

// Quit Access and clean up.
accessData.CloseCurrentDatabase();
accessData.Quit(Access.AcQuitOption.acQuitSaveNone);
Marshal.ReleaseComObject(accessData);
accessData = null;

Thanks!
Ezhil

 

[Ray Costanzo [MVP]]

I think you may want to visit an Access programming group. This isn't ASP
(Active Server Pages) related. At least I hope this isn't an ASP snippet...

Ray at work

 

[Bob Barrows [MVP]]

Access.Application accessData;
accessData = new Access.ApplicationClass();

There was no way for you to know it, but this is a classic asp newsgroup.
While you may be lucky enough to find a dotnet-savvy person here who can
answer your question, you can eliminate the luck factor by posting your
question to a group where those dotnet-savvy people hang out. I suggest
microsoft.public.dotnet.framework.aspnet.

 

[Ezhil]

Hi Rai-

I am sorry that i did not give the details about environment. This web
application is developed with ASP.Net (using C#).

 

[Ezhil]

Bob-

I am sorry, some how i got confused with asp and asp.net groups. Thanks for
you suggestion. I will post query asp.net groups.

Thanks!
Ezhil