error in snapshot generating code (asp)
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".
please find below the asp code for this.
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
But while executing this asp code ,i am getting the following error in my IE browser.
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.