OK, just to update you - if you care - I never did figure out which Com object is responsible for Access. However, I did come across a nice C# function that will kill a process by its name. So I modified it and added it to my page. Now, when I run the code, I also run the function that will kill the process generated by the code.
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 1:16 PM To: dotnet Subject: RE: ASP.NET and COM Objects OK, I've come across a page on Goolge that explains that in .NET, COM objects are encapsulated by adding a reference to them in the solution explorer in Visual Studio (I have no idea how to do it otherwise). Then VS will generate a wrapper class that has all the functionality of the COM object. The next question: which COM object is the Access application a part of? I've looked in OLEVIEWER, I still have no idea which it is how I would tell it in the future. 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: David L. Penton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 12:36 PM To: dotnet Subject: RE: ASP.NET and COM Objects ASP.Net is holding a handle open to the MSA database. A couple of possible options (not in any particular order): 1) Make a COM component [in VB6] that encapsulated this functionality. Make a COM interop file for it (tlbimp.exe) 2) Make a standalone process which waits for messages (from your ASP.Net page) 3) Make a .vbs file which encapsulates this code. Use System.Diagnostics.Process.Start() (I think that is the right one) to run this vbs file 4) Figure out how to implement .Dispose() on the objAccess variable David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: Matthew Small [mailto:[EMAIL PROTECTED]] Here is my code, it still does not appear to be working. I am still leaving an instance open every time I run this code. What am I doing wrong? dim objAccess, objReport objAccess = Server.CreateObject("Access.Application") objAccess.OpenCurrentDatabase ("c:\inetpub\db\checkbook.mdb") objAccess.doCmd.OpenReport("aggregate_report-account_order") objAccess.doCmd.Close() objAccess.CloseCurrentDatabase() objAccess.Application.Quit() objAccess = nothing 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/
