Hi--
I have a website that generates .rtf documents via MS
Access, thereby creating a background MS Access process.
The ASP code has the following segment that does this:
------------------
var access = new ActiveXObject('Access.Application');
var basefilename = reportName + Request("accountID".Item
+ (new Date()).getTime() + ".rtf";
var url = "/views/letters/" + basefilename;
var filename = Server.MapPath(url);
try
{
access.OpenCurrentDatabase
(getReportDatabaseFilename());
access.DoCmd.OpenReport(reportName, 2 /* acPreview
*/, "", "[accountID]='" + Request("accountID".Item + "'"
access.DoCmd.OutputTo(3 /* acReport */, "",
"Rich Text Format (*.rtf)", filename, false, ""
access.DoCmd.Close();
}
catch(exception)
{
access.Application.Quit();
access = null;
throw(exception);
}
access.Application.Quit();
access = null;
------------------
However, after generating the .rtf document, the access
process that was created by the user does not end - it
hangs around on the web server. Any idea why this is
happening?
Any help would be much appreciated!
Thanks,
- JPA
I have a website that generates .rtf documents via MS
Access, thereby creating a background MS Access process.
The ASP code has the following segment that does this:
------------------
var access = new ActiveXObject('Access.Application');
var basefilename = reportName + Request("accountID".Item
+ (new Date()).getTime() + ".rtf";
var url = "/views/letters/" + basefilename;
var filename = Server.MapPath(url);
try
{
access.OpenCurrentDatabase
(getReportDatabaseFilename());
access.DoCmd.OpenReport(reportName, 2 /* acPreview
*/, "", "[accountID]='" + Request("accountID".Item + "'"
access.DoCmd.OutputTo(3 /* acReport */, "",
"Rich Text Format (*.rtf)", filename, false, ""
access.DoCmd.Close();
}
catch(exception)
{
access.Application.Quit();
access = null;
throw(exception);
}
access.Application.Quit();
access = null;
------------------
However, after generating the .rtf document, the access
process that was created by the user does not end - it
hangs around on the web server. Any idea why this is
happening?
Any help would be much appreciated!
Thanks,
- JPA