hi
i have a problem with devoloping an asp program ,that is dynamically generating snapshot files (in .snp format)from
a MS-access database.
database name is datafile.mdb.
Report name is "reportTarge".
here is the asp code for this.
<%
Dim objAccess
Set objAccess = Server.CreateObject("Access.Application")
objAccess.OpenCurrentDatabase request("APPL_PHYSICAL_PATH") & "databasename.mdb"
objAccess.DoCmd.OutputTo 3, "reportName", "Snapshot Format (*.snp)", "snapshotname.snp", 0
objAccess.DoCmd.Quit 2
%>
But while executing this asp code ,i am getting the following error in my IE browser.
Error Type:
Server object, ASP 0178 (0x80070005)
The call to Server.CreateObject failed while checking permissions. Access is denied to this object.
What is the reason of this error (while creating instance of the access)?.
Is there any problem with my IIS server setting ?If there, how to solve it?
Please help me?
Thanking in advance.
From Vinod