|
Home > Archive > IIS ASP > December 2004 > Could not quit MSACCESS.EXE
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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.acStructureAndData);
// Quit Access and clean up.
accessData.CloseCurrentDatabase();
accessData.Quit(Access.AcQuitOption.acQuitSaveNone);
Marshal.ReleaseComObject(accessData);
accessData = null;
Thanks!
Ezhil
| |
| Ray Costanzo [MVP] 2004-12-27, 5:49 pm |
| 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
>
>
| |
| Bob Barrows [MVP] 2004-12-27, 5:49 pm |
| 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.acStructure
> AndData);
>
>
>
>
| |
|
| 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
"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"
>
>
>
|
|
|
|
|