Permissions Problems with Server.CreateObject("Access.Application")

Hi,
Having a nightmare with IIS permissions.

I have an ASP application reading and updating an ACCESS database
successfully. I have authorisation to view the pages when using
IUSR_Servername.
However whenever I try and use the command

Server.CreateObject("Access.Application")

I get an error. (I having it working fine on a different computer, so I
know it is possible!).

I have tried all manner of permissions changes including:
1)Changing the Identity of Access from "The Launching User" to "The
Interactive user"
2)In folder 'Directory Security', changing IUSR_Servername to
IWAM_Servername, blank password, unchecking "Allow IIS to Control
password' box. This fix worked on the other computer, but here,
suddenly I cannot view any of the asp pages at all! I get a "You are
not authorized to view this page" error.

Please could someone help! Its driving me nuts. i have unistalled and
reinstalled IIS several times as well.

Thanks,
Lynn

Re: Permissions Problems with Server.CreateObject("Access.Application")

WolfWoman wrote:
> Hi,
> Having a nightmare with IIS permissions.
>
> I have an ASP application reading and updating an ACCESS database
> successfully. I have authorisation to view the pages when using
> IUSR_Servername.
> However whenever I try and use the command
>
> Server.CreateObject("Access.Application")

http://support.microsoft.com/default.aspx?scid=kb;en-us;2577 57

If you let us know what you are attempting to accomplish by automating
Access, we may be able to suggest an alternative that is more suitable for
server-side scripting.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Permissions Problems with Server.CreateObject("Access.Application")

"WolfWoman" wrote in message
news:1120481364.838058.162820@g43g2000cwa.googlegroups.com.. .
> Hi,
> Having a nightmare with IIS permissions.
>
> I have an ASP application reading and updating an ACCESS database
> successfully. I have authorisation to view the pages when using
> IUSR_Servername.
> However whenever I try and use the command
>
> Server.CreateObject("Access.Application")
>
> I get an error. (I having it working fine on a different computer, so I
> know it is possible!).

Is MS-Access installed on the server?

Re: Permissions Problems with Server.CreateObject("Access.Application")

Yes it is.

Re: Permissions Problems with Server.CreateObject("Access.Application")

WolfWoman wrote:
> Yes it is.

What is what? What are you replying to?

In usenet, it is very helpful to quote enough of the message to which you
are replying to allow readers to follow the conversation without having to
load the previous messages in the thread into their news readers. You may be
using a web interface to post your messages, but the majority of people
reading your posts are doing so via usenet.

If the "netiquette" argument does not sway you, think of it this way: you
don't want the people who are most able to help you to simply ignore your
messages, do you? It simply makes sense to comply with basic netiquette.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Permissions Problems with Server.CreateObject("Access.Application")

"WolfWoman" wrote in message
news:1120561286.353363.93640@g49g2000cwa.googlegroups.com...
> Yes it is.
>

Try
Server.CreateObject("Access.Application.#")
where
"Access.Application.8" = Access 97
"Access.Application.9" = Access 2000
"Access.Application.10" = Access XP
"Access.Application.11" = Access 2003