Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_web_howto thread: RE: Reports from Access/SQL


Message #1 by "Rocio Ojeda" <rojeda@t...> on Fri, 15 Feb 2002 10:33:32
Hi Raman,



I´ve seen you have solved a similar problem that I have.  I´m trying to 

work with Access reports from ASP (printing, preview, etc).



I´m quite confused about the method I should use. I send you my code and 

see if you can help me (I get an error):



'Get the IIsWebService Admin object

  Set oWebService = GetObject("IIS://LocalHost/W3svc")



 'Enable the AspAllowOutOfProcComponents Parameter

 VDirObj.Put "AspAllowOutOfProcComponents", True



 'Save the changed value to the metabase

 VDirObj.SetInfo



dim objAccess

set objAccess = server.createobject("Access.Application")

objAccess.OpenCurrentDatabase "\data\comerciales.mdb"

objAccess.DoCmd.OutputTo 3, "10-REPORT_IEG", "Snapshot Format .snp)", "10-

REPORT_IEG.snp"

objAccess.DoCmd.Quit 2



Thank you in advance.

Rocio.

  Return to Index