Actually, I have one problem. I am now leaving an instance of Access open on my server each time I run my application to print out my report. How can I kill this process when it's done?
Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 11:28 AM To: dotnet Subject: RE: ASP.NET and COM Objects Thanks for the response, I finally got someone to notice me. :-) Actually, I have solved the issue that I had. I needed to open up an access database to send a report to the local intranet printer when a user clicks on a button in my intranet application. It turns out that the user that ASP.NET runs under did not have enough privileges to open up the Access file. I changed the user in the machine.config file to system and now it works fine. I am in an intranet setting where security is of very low concern so I am not worried about the implications of doing that. Thanks for your help. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Kenneth Courville [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 11:12 AM To: dotnet Subject: RE: ASP.NET and COM Objects Do you actually need to create an Access session? Or are you just trying to access the database? -----Original Message----- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: Monday, September 16, 2002 3:10 PM Subject: RE: ASP.NET and COM Objects Hi, I'm not expert on COM. I'm trying to open up Access through a COM object to print a report to the local intranet, but I am having security issues. I've already done what the error message tells me to do to remedy the situation, but it still doesn't work. Any ideas? Does anybody read these posts? I don't get any answers, but I will keep on trying. The error message: Access is denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.UnauthorizedAccessException: Access is denied. The ASP.NET process is not authorized to access the requested resource. For security reasons the default ASP.NET process identity is '{machinename}\ASPNET', which has limited privileges. Consider granting access rights to the resource to the ASP.NET process identity. To grant ASP.NET write access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the "{machinename}\ASPNET" user. Highlight the ASP.NET account, and check the Write box in the Allow column. Offending code: objAccess = Server.CreateObject("Access.Application") Thank you, Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com --- You are currently subscribed to dotnet as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --------- Administrated by 15 Seconds : http://www.15Seconds.com List Archives/Search : http://local.15Seconds.com/search Subscription Information : http://www.15seconds.com/listserv.htm Advertising Information: http://www.internet.com/mediakit/ --- You are currently subscribed to dotnet as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --------- Administrated by 15 Seconds : http://www.15Seconds.com List Archives/Search : http://local.15Seconds.com/search Subscription Information : http://www.15seconds.com/listserv.htm Advertising Information: http://www.internet.com/mediakit/ --- You are currently subscribed to dotnet as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------- Administrated by 15 Seconds : http://www.15Seconds.com List Archives/Search : http://local.15Seconds.com/search Subscription Information : http://www.15seconds.com/listserv.htm Advertising Information: http://www.internet.com/mediakit/
