"Bill Murphy" <wmurphy@houston.rr.com> wrote in message
news:3TbWa.132491$hV.8923957@twister.austin.rr.com...
> I've read the various Microsoft Knowledgebase white papers stressing the
> fact that Microsoft does not recommend running any Office application,
> including Access, in an automation mode. Risky and unstable, potential
for
> crashing the Web server.
>
> One of my goals with the application I am working on is to allow the user
to
> input some parameters, for example a begin date and an end date, and view
a
> report using data from an Access MDB on screen, with an option to print
the
> report. If I just connect to the Access tables using ADO this will
provide
> the data, but are there reporting packages available that will display the
> data in reports as described above? I like the report designer in Access,
> but apparently this cannot be used unless Access is started under
> automation.
>
> Bill
>
>
> "John Beschler" <giles@geewhiz.com> wrote in message
> news:0cc101c35776$d76e66c0$a601280a@phx.gbl...
> > Bill,
> >
> > Here is a page that tells how to create connections to
> > various databases (including access). AS someone has
> > already mentioned, you do not need Access on the server to
> > retrieve data from access tables. Therefore, you do NOT
> > need to create an "Access.Application"
> >
> >
> > http://www.aspfaq.com/show.asp?id=2126
> >
> > EXAMPLE: (VBCsript)
> > Dim szConn, objConn, objRS, szSQL
> > szConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
> > szConn = szConn & server.mappath("/<pathtofile.mdb>")
> > Set objConn = Server.CreateObject("ADODB.Connection")
> > objConn.Open szConn
> > szSQL = "SELECT Lname, Fname, MI, SSAN " _
> > & " FROM Employees " _
> > & " WHERE TermDate IS NULL "
> > Set objRS = objConn.Execute szSQL
> >
> > At this point you have a recordset which contains the data
> > requested from your table.
> >
> > HTH,
> > John
> >
> >
> > >-----Original Message-----
> > >In an ASP file I am running the following in VBScript in
> > order to extract
> > >data from an Access 2002 MDB file which is physically
> > located in the virtual
> > >directory in PWS along with the ASP file:
> > >
> > > dim objAccess
> > > set objAccess = Server.CreateObject
> > ("Access.Application")
> > >
> > >When the second line executes I am getting error "ASP
> > 0178 -
> > >Server.CreateObject Access Error. The call to
> > Server.CreateObject failed
> > >while checking permissions. Access is denied to this
> > object."
> > >
> > >I have Access 2002 installed on the same Windows 2000
> > Professional PC as the
> > >Personal Web Server and the virtual directory for the ASP
> > file.
> > >
> > >I would appreciate any thoughts on why access is denied.
> > >
> > >Bill
> > >
> > >
> > >.
> > >
>
>

"John Beschler" <giles@geewhiz.com> wrote in message
news:0cc101c35776$d76e66c0$a601280a@phx.gbl...
> Bill,
>
> Here is a page that tells how to create connections to
> various databases (including access). AS someone has
> already mentioned, you do not need Access on the server to
> retrieve data from access tables. Therefore, you do NOT
> need to create an "Access.Application"
>
>
> http://www.aspfaq.com/show.asp?id=2126
>
> EXAMPLE: (VBCsript)
> Dim szConn, objConn, objRS, szSQL
> szConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
> szConn = szConn & server.mappath("/<pathtofile.mdb>")
> Set objConn = Server.CreateObject("ADODB.Connection")
> objConn.Open szConn
> szSQL = "SELECT Lname, Fname, MI, SSAN " _
> & " FROM Employees " _
> & " WHERE TermDate IS NULL "
> Set objRS = objConn.Execute szSQL
>
> At this point you have a recordset which contains the data
> requested from your table.
>
> HTH,
> John
>
>
> >-----Original Message-----
> >In an ASP file I am running the following in VBScript in
> order to extract
> >data from an Access 2002 MDB file which is physically
> located in the virtual
> >directory in PWS along with the ASP file:
> >
> > dim objAccess
> > set objAccess = Server.CreateObject
> ("Access.Application")
> >
> >When the second line executes I am getting error "ASP
> 0178 -
> >Server.CreateObject Access Error. The call to
> Server.CreateObject failed
> >while checking permissions. Access is denied to this
> object."
> >
> >I have Access 2002 installed on the same Windows 2000
> Professional PC as the
> >Personal Web Server and the virtual directory for the ASP
> file.
> >
> >I would appreciate any thoughts on why access is denied.
> >
> >Bill
> >
> >
> >.
> >