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 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/
