I'm running the below code to display a MS Access Rpt from a .ASP page. The code works on a server with IIS 5 and Windows 2000, but the code does not work on IIS 6 and Windows 2003. I would appreciate any help someone could give me. Thanks.


Set objAccess = Server.CreateObject("Access.Application")
objAccess.Visible = False


objAccess.OpenCurrentDatabase strDbName

With objAccess.DoCmd

.OpenReport strRptName, acViewPreview, strFilter, strWhere

.OutputTo acOutputReport, "rpt_individualphonelist", "Snapshot Format", strSnapFileAb
.Close
End With


objAccess.Quit acQuitSaveNone
Set objAccess = Nothing