Could not quit MSACCESS.EXE

[Guest]

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

 

[Ken Cox [Microsoft MVP]]

Hi Ezhil,

I think you're going about this the wrong way. You shouldn't be running the
Access application to insert data. You should be using the data tools that
..NET provides to add the data.

You're going to get into trouble with using Office applications this way.

Check out the way .mdb files are used here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadvnet/html/vbnet05282002.asp