Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access processes start but do not end

Status
Not open for further replies.

jpa

Programmer
Oct 15, 2001
16
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top