Could not quit MSACCESS.EXE

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.acStructure
AndData);

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

Thanks!
Ezhil

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

"Ezhil" <ezhilsundaram@yahoo.com> wrote in message
news:0173D0D5-545F-4FA9-9B52-4A5341897032@microsoft.com...
> 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.acStructure
AndData);
>
> // Quit Access and clean up.
> accessData.CloseCurrentDatabase();
> accessData.Quit(Access.AcQuitOption.acQuitSaveNone);
> Marshal.ReleaseComObject(accessData);
> accessData = null;
>
> Thanks!
> Ezhil
>
>

Ezhil wrote:

> 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.


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Hi Rai-

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

"Ray Costanzo [MVP]" wrote:

> 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
>
> "Ezhil" <ezhilsundaram@yahoo.com> wrote in message
> news:0173D0D5-545F-4FA9-9B52-4A5341897032@microsoft.com... 
> is 
> I 
> forums, 
> can 
> accessData.ImportXML("C:\Test\Test.xml",Access.AcImportXMLOption.acStructu
re
> AndData); 
>
>
>
>

Bob-

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

Thanks!
Ezhil

"Bob Barrows [MVP]" wrote:

> Ezhil wrote:
> 
>
> 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.
>
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
>