The call to Server.CreateObject failed while checking permissions. Access is denied t

[JohnSmith]

I setup my XP workstation as a web server (IIS). I am trying to run this code:

<%@ Language=VBScript %>
<% rpt_filter = "123456"
Set oApp = Server.CreateObject("Access.Application")
oApp.OpenCurrentDatabase "C:\Test.mdb"
Set oDoCmd = oApp.DoCmd
FileName= "fecal" + ".snp"
oDoCmd.OpenReport "Report1",acViewPreview,,"PROCESSBATCHID="&rpt_filter
oDoCmd.OutputTo 3, "Report1","Snapshot Format",Server.MapPath(FileName)
set oDoCmd = Nothing
Set oApp = Nothing %>

I get the following error when I run it from the xp workstation:


Error Type:
Server object, ASP 0178 (0x80070005)
The call to Server.CreateObject failed while checking permissions. Access is denied to this object.
/test.asp, line 3

How can I resolve this. Sounds like a permission problem? I know nothing about modifying permissions. If this is the resolution, can you please show me how to make the correct modifications?

Your help is greatly appreciated in this matter.

[mendhak]

You probably need to set permissions on msvbvm60.dll. Right click it, give everyone full control.

If that doesn't work, it'll have to be the MDAC files on your machine, but I think it should be msvbvm60.dll.

[Danial]

You probably need to set permissions on msvbvm60.dll. Right click it, give everyone full control.

If that doesn't work, it'll have to be the MDAC files on your machine, but I think it should be msvbvm60.dll.

I think I came accross this error before. Its to do with permission, more specifically when CreateObject is performed IIS uses the default account(IWAM_User or something like that) which does not have the permission to create an instance. There was a knowledgebase article on how to resolve it. If I can dig it up I will post it.

[mendhak]

Do you mean IWAM_xyz or IUSR_xyz?

[JohnSmith]

Can someone try my code and tell me if it works for you...

[lchi]

I encounted this problem many time before now my computer. All you need to do is add (IUSR_COMNAME) or Internet Guest Account and allow the permission to Full Control.

Irwin

[JohnSmith]

How do I do this... I am new to permissions, etc... Your help is appreciated...

[lchi]

Simple, you right click on the object you want to open and go to Security tab and click on the button Add. Then find the IUSR_YOURCOMNAME and add it. After adding just allow Full Control. My workstation is win200 hope it is the method with win XP.

Irwin

[HimAgain]

Maybe this solution has worked before, but on Windows Vista the rights on msVbVm60.dll can't be chanched! After changing the settings the apply button issues the message "Can't save changes in the rights on msvbvm60.dell. Access denied" (translated from ducth).

HELP!!!