IIS7/Vista Access database

Try
Error message when you request an ASP page that connects to an Access
database in IIS 7.0: "Microsoft JET Database Engine error '80004005'"
http://support.microsoft.com/?id=926939

look at the workaround section.
%windir%\system32\inetsrv\appcmd set appPool
"YourAppPool" -processModel.loadUserProfile:false

--
Regards,
Bernard Cheah
http://www.iis.net/
http://www.iis-resources.com/
http://msmvps.com/blogs/bernard/


"Sir Benjamin Nunn" <bennunn RemoveThis @depro.co.uk> wrote in message
news:58d0e7F1mbgp6U1@mid.individual.net...
> Hi there,
>
> I develop websites on my local machine, and need to work on a site that
> connects to an MS Access .MDB file via Classic ASP.
>
> It worked fine for years under Windows XP Pro, but on Vista Ultimate (IIS
> 7) it gives me the unhelpful error message:
>
> Microsoft JET Database Engine error '80004005' Unspecified error
>
> I've found a lot of 'solutions' online, none of which seem to address my
> specific problem. I needed to enable permissions on the folder for the
> Internet Guest User Account, which made no difference.
>
> If anyone has any ideas for how to get this to work that would be great.
>
> For now I'm going to set up an XP partition to do work on this, but that's
> hardly a long-term solution.
>
> BTN
 >> Stay informed about: IIS7/Vista Access database 

Hi

I have exactly the same problem and am trying to take your advice.
Problem is the MS Help Note says you have to amend the
"applicationHost.config" file.
I've found the file but I can't open it. All I get is access is denied.
I'm an administrator so I've no idea what to do next. Can you help please?

Incidentally, I've already tried the "Resolution" part of the Technote and
that hasn't worked.

Classic ASP works as in <%=Now%> but no database connection.

Ken

"Bernard Cheah [MVP]" <qbernard.RemoveThis@hotmail.com.discuss> wrote in message
news:uHB5l%23%23fHHA.3676@TK2MSFTNGP05.phx.gbl...
> Try
> Error message when you request an ASP page that connects to an Access
> database in IIS 7.0: "Microsoft JET Database Engine error '80004005'"
> http://support.microsoft.com/?id=926939
>
> look at the workaround section.
> %windir%\system32\inetsrv\appcmd set appPool
> "YourAppPool" -processModel.loadUserProfile:false
>
> --
> Regards,
> Bernard Cheah
> http://www.iis.net/
> http://www.iis-resources.com/
> http://msmvps.com/blogs/bernard/
>
>
> "Sir Benjamin Nunn" <bennunn.RemoveThis@depro.co.uk> wrote in message
> news:58d0e7F1mbgp6U1@mid.individual.net...
>> Hi there,
>>
>> I develop websites on my local machine, and need to work on a site that
>> connects to an MS Access .MDB file via Classic ASP.
>>
>> It worked fine for years under Windows XP Pro, but on Vista Ultimate (IIS
>> 7) it gives me the unhelpful error message:
>>
>> Microsoft JET Database Engine error '80004005' Unspecified error
>>
>> I've found a lot of 'solutions' online, none of which seem to address my
>> specific problem. I needed to enable permissions on the folder for the
>> Internet Guest User Account, which made no difference.
>>
>> If anyone has any ideas for how to get this to work that would be great.
>>
>> For now I'm going to set up an XP partition to do work on this, but
>> that's hardly a long-term solution.
>>
>> BTN
>
>
 >> Stay informed about: IIS7/Vista Access database 

Hi,

You need to elevate your privileges to be able to open
applicationHost.config. Right-click on Notepad.exe and choose "Run as
Administrator". Then you can open/amend applicationHost.config.

Cheers
Ken

"Ken Renwick" <ken.TakeThisOut@nospamrdsweb.co.uk> wrote in message
news:eKvE1vCgHHA.4936@TK2MSFTNGP04.phx.gbl...
> Hi
>
> I have exactly the same problem and am trying to take your advice.
> Problem is the MS Help Note says you have to amend the
> "applicationHost.config" file.
> I've found the file but I can't open it. All I get is access is denied.
> I'm an administrator so I've no idea what to do next. Can you help please?
>
> Incidentally, I've already tried the "Resolution" part of the Technote and
> that hasn't worked.
>
> Classic ASP works as in <%=Now%> but no database connection.
>
> Ken
>
> "Bernard Cheah [MVP]" <qbernard.TakeThisOut@hotmail.com.discuss> wrote in message
> news:uHB5l%23%23fHHA.3676@TK2MSFTNGP05.phx.gbl...
>> Try
>> Error message when you request an ASP page that connects to an Access
>> database in IIS 7.0: "Microsoft JET Database Engine error '80004005'"
>> http://support.microsoft.com/?id=926939
>>
>> look at the workaround section.
>> %windir%\system32\inetsrv\appcmd set appPool
>> "YourAppPool" -processModel.loadUserProfile:false
>>
>> --
>> Regards,
>> Bernard Cheah
>> http://www.iis.net/
>> http://www.iis-resources.com/
>> http://msmvps.com/blogs/bernard/
>>
>>
>> "Sir Benjamin Nunn" <bennunn.TakeThisOut@depro.co.uk> wrote in message
>> news:58d0e7F1mbgp6U1@mid.individual.net...
>>> Hi there,
>>>
>>> I develop websites on my local machine, and need to work on a site that
>>> connects to an MS Access .MDB file via Classic ASP.
>>>
>>> It worked fine for years under Windows XP Pro, but on Vista Ultimate
>>> (IIS 7) it gives me the unhelpful error message:
>>>
>>> Microsoft JET Database Engine error '80004005' Unspecified error
>>>
>>> I've found a lot of 'solutions' online, none of which seem to address my
>>> specific problem. I needed to enable permissions on the folder for the
>>> Internet Guest User Account, which made no difference.
>>>
>>> If anyone has any ideas for how to get this to work that would be great.
>>>
>>> For now I'm going to set up an XP partition to do work on this, but
>>> that's hardly a long-term solution.
>>>
>>> BTN
>>
>>
>
 >> Stay informed about: IIS7/Vista Access database 

Yes, this required administrator access.

--
Regards,
Bernard Cheah
http://www.iis.net/
http://www.iis-resources.com/
http://msmvps.com/blogs/bernard/


"Ken Schaefer" <kenREMOVE.RemoveThis@THISadOpenStatic.com> wrote in message
news:ugqGa$IgHHA.4536@TK2MSFTNGP04.phx.gbl...
> Hi,
>
> You need to elevate your privileges to be able to open
> applicationHost.config. Right-click on Notepad.exe and choose "Run as
> Administrator". Then you can open/amend applicationHost.config.
>
> Cheers
> Ken
>
> "Ken Renwick" <ken.RemoveThis@nospamrdsweb.co.uk> wrote in message
> news:eKvE1vCgHHA.4936@TK2MSFTNGP04.phx.gbl...
>> Hi
>>
>> I have exactly the same problem and am trying to take your advice.
>> Problem is the MS Help Note says you have to amend the
>> "applicationHost.config" file.
>> I've found the file but I can't open it. All I get is access is denied.
>> I'm an administrator so I've no idea what to do next. Can you help
>> please?
>>
>> Incidentally, I've already tried the "Resolution" part of the Technote
>> and that hasn't worked.
>>
>> Classic ASP works as in <%=Now%> but no database connection.
>>
>> Ken
>>
>> "Bernard Cheah [MVP]" <qbernard.RemoveThis@hotmail.com.discuss> wrote in message
>> news:uHB5l%23%23fHHA.3676@TK2MSFTNGP05.phx.gbl...
>>> Try
>>> Error message when you request an ASP page that connects to an Access
>>> database in IIS 7.0: "Microsoft JET Database Engine error '80004005'"
>>> http://support.microsoft.com/?id=926939
>>>
>>> look at the workaround section.
>>> %windir%\system32\inetsrv\appcmd set appPool
>>> "YourAppPool" -processModel.loadUserProfile:false
>>>
>>> --
>>> Regards,
>>> Bernard Cheah
>>> http://www.iis.net/
>>> http://www.iis-resources.com/
>>> http://msmvps.com/blogs/bernard/
>>>
>>>
>>> "Sir Benjamin Nunn" <bennunn.RemoveThis@depro.co.uk> wrote in message
>>> news:58d0e7F1mbgp6U1@mid.individual.net...
>>>> Hi there,
>>>>
>>>> I develop websites on my local machine, and need to work on a site that
>>>> connects to an MS Access .MDB file via Classic ASP.
>>>>
>>>> It worked fine for years under Windows XP Pro, but on Vista Ultimate
>>>> (IIS 7) it gives me the unhelpful error message:
>>>>
>>>> Microsoft JET Database Engine error '80004005' Unspecified error
>>>>
>>>> I've found a lot of 'solutions' online, none of which seem to address
>>>> my specific problem. I needed to enable permissions on the folder for
>>>> the Internet Guest User Account, which made no difference.
>>>>
>>>> If anyone has any ideas for how to get this to work that would be
>>>> great.
>>>>
>>>> For now I'm going to set up an XP partition to do work on this, but
>>>> that's hardly a long-term solution.
>>>>
>>>> BTN
>>>
>>>
>>
>
 >> Stay informed about: IIS7/Vista Access database 

Thanks guys

I actually managed to do it by opening the command prompt as administrator
and typing it manually

Best thing is, problem solved

I cannot believe that we have to jump through hoops like this to continue
the functionality we took for granted in Windows XP Pro

Ken

"Bernard Cheah [MVP]" <qbernard.RemoveThis@hotmail.com.discuss> wrote in message
news:uHT$TtMgHHA.4552@TK2MSFTNGP04.phx.gbl...
> Yes, this required administrator access.
>
> --
> Regards,
> Bernard Cheah
> http://www.iis.net/
> http://www.iis-resources.com/
> http://msmvps.com/blogs/bernard/
>
>
> "Ken Schaefer" <kenREMOVE.RemoveThis@THISadOpenStatic.com> wrote in message
> news:ugqGa$IgHHA.4536@TK2MSFTNGP04.phx.gbl...
>> Hi,
>>
>> You need to elevate your privileges to be able to open
>> applicationHost.config. Right-click on Notepad.exe and choose "Run as
>> Administrator". Then you can open/amend applicationHost.config.
>>
>> Cheers
>> Ken
>>
>> "Ken Renwick" <ken.RemoveThis@nospamrdsweb.co.uk> wrote in message
>> news:eKvE1vCgHHA.4936@TK2MSFTNGP04.phx.gbl...
>>> Hi
>>>
>>> I have exactly the same problem and am trying to take your advice.
>>> Problem is the MS Help Note says you have to amend the
>>> "applicationHost.config" file.
>>> I've found the file but I can't open it. All I get is access is denied.
>>> I'm an administrator so I've no idea what to do next. Can you help
>>> please?
>>>
>>> Incidentally, I've already tried the "Resolution" part of the Technote
>>> and that hasn't worked.
>>>
>>> Classic ASP works as in <%=Now%> but no database connection.
>>>
>>> Ken
>>>
>>> "Bernard Cheah [MVP]" <qbernard.RemoveThis@hotmail.com.discuss> wrote in message
>>> news:uHB5l%23%23fHHA.3676@TK2MSFTNGP05.phx.gbl...
>>>> Try
>>>> Error message when you request an ASP page that connects to an Access
>>>> database in IIS 7.0: "Microsoft JET Database Engine error '80004005'"
>>>> http://support.microsoft.com/?id=926939
>>>>
>>>> look at the workaround section.
>>>> %windir%\system32\inetsrv\appcmd set appPool
>>>> "YourAppPool" -processModel.loadUserProfile:false
>>>>
>>>> --
>>>> Regards,
>>>> Bernard Cheah
>>>> http://www.iis.net/
>>>> http://www.iis-resources.com/
>>>> http://msmvps.com/blogs/bernard/
>>>>
>>>>
>>>> "Sir Benjamin Nunn" <bennunn.RemoveThis@depro.co.uk> wrote in message
>>>> news:58d0e7F1mbgp6U1@mid.individual.net...
>>>>> Hi there,
>>>>>
>>>>> I develop websites on my local machine, and need to work on a site
>>>>> that connects to an MS Access .MDB file via Classic ASP.
>>>>>
>>>>> It worked fine for years under Windows XP Pro, but on Vista Ultimate
>>>>> (IIS 7) it gives me the unhelpful error message:
>>>>>
>>>>> Microsoft JET Database Engine error '80004005' Unspecified error
>>>>>
>>>>> I've found a lot of 'solutions' online, none of which seem to address
>>>>> my specific problem. I needed to enable permissions on the folder for
>>>>> the Internet Guest User Account, which made no difference.
>>>>>
>>>>> If anyone has any ideas for how to get this to work that would be
>>>>> great.
>>>>>
>>>>> For now I'm going to set up an XP partition to do work on this, but
>>>>> that's hardly a long-term solution.
>>>>>
>>>>> BTN
>>>>
>>>>
>>>
>>
>
>
 >> Stay informed about: IIS7/Vista Access database 

New UAC feature introduced in Vista

--
Regards,
Bernard Cheah
http://www.iis.net/
http://www.iis-resources.com/
http://msmvps.com/blogs/bernard/


"Ken Renwick" <ken.RemoveThis@nospamrdsweb.co.uk> wrote in message
news:uUDuAWPgHHA.5052@TK2MSFTNGP05.phx.gbl...
> Thanks guys
>
> I actually managed to do it by opening the command prompt as administrator
> and typing it manually
>
> Best thing is, problem solved
>
> I cannot believe that we have to jump through hoops like this to continue
> the functionality we took for granted in Windows XP Pro
>
> Ken
>
> "Bernard Cheah [MVP]" <qbernard.RemoveThis@hotmail.com.discuss> wrote in message
> news:uHT$TtMgHHA.4552@TK2MSFTNGP04.phx.gbl...
>> Yes, this required administrator access.
>>
>> --
>> Regards,
>> Bernard Cheah
>> http://www.iis.net/
>> http://www.iis-resources.com/
>> http://msmvps.com/blogs/bernard/
>>
>>
>> "Ken Schaefer" <kenREMOVE.RemoveThis@THISadOpenStatic.com> wrote in message
>> news:ugqGa$IgHHA.4536@TK2MSFTNGP04.phx.gbl...
>>> Hi,
>>>
>>> You need to elevate your privileges to be able to open
>>> applicationHost.config. Right-click on Notepad.exe and choose "Run as
>>> Administrator". Then you can open/amend applicationHost.config.
>>>
>>> Cheers
>>> Ken
>>>
>>> "Ken Renwick" <ken.RemoveThis@nospamrdsweb.co.uk> wrote in message
>>> news:eKvE1vCgHHA.4936@TK2MSFTNGP04.phx.gbl...
>>>> Hi
>>>>
>>>> I have exactly the same problem and am trying to take your advice.
>>>> Problem is the MS Help Note says you have to amend the
>>>> "applicationHost.config" file.
>>>> I've found the file but I can't open it. All I get is access is denied.
>>>> I'm an administrator so I've no idea what to do next. Can you help
>>>> please?
>>>>
>>>> Incidentally, I've already tried the "Resolution" part of the Technote
>>>> and that hasn't worked.
>>>>
>>>> Classic ASP works as in <%=Now%> but no database connection.
>>>>
>>>> Ken
>>>>
>>>> "Bernard Cheah [MVP]" <qbernard.RemoveThis@hotmail.com.discuss> wrote in message
>>>> news:uHB5l%23%23fHHA.3676@TK2MSFTNGP05.phx.gbl...
>>>>> Try
>>>>> Error message when you request an ASP page that connects to an Access
>>>>> database in IIS 7.0: "Microsoft JET Database Engine error '80004005'"
>>>>> http://support.microsoft.com/?id=926939
>>>>>
>>>>> look at the workaround section.
>>>>> %windir%\system32\inetsrv\appcmd set appPool
>>>>> "YourAppPool" -processModel.loadUserProfile:false
>>>>>
>>>>> --
>>>>> Regards,
>>>>> Bernard Cheah
>>>>> http://www.iis.net/
>>>>> http://www.iis-resources.com/
>>>>> http://msmvps.com/blogs/bernard/
>>>>>
>>>>>
>>>>> "Sir Benjamin Nunn" <bennunn.RemoveThis@depro.co.uk> wrote in message
>>>>> news:58d0e7F1mbgp6U1@mid.individual.net...
>>>>>> Hi there,
>>>>>>
>>>>>> I develop websites on my local machine, and need to work on a site
>>>>>> that connects to an MS Access .MDB file via Classic ASP.
>>>>>>
>>>>>> It worked fine for years under Windows XP Pro, but on Vista Ultimate
>>>>>> (IIS 7) it gives me the unhelpful error message:
>>>>>>
>>>>>> Microsoft JET Database Engine error '80004005' Unspecified error
>>>>>>
>>>>>> I've found a lot of 'solutions' online, none of which seem to address
>>>>>> my specific problem. I needed to enable permissions on the folder for
>>>>>> the Internet Guest User Account, which made no difference.
>>>>>>
>>>>>> If anyone has any ideas for how to get this to work that would be
>>>>>> great.
>>>>>>
>>>>>> For now I'm going to set up an XP partition to do work on this, but
>>>>>> that's hardly a long-term solution.
>>>>>>
>>>>>> BTN
>>>>>
>>>>>
>>>>
>>>
>>
>>
>
 >> Stay informed about: IIS7/Vista Access database 

It stops potentially malicious code doing what you just did interactively
(namely changing/altering critical system configuration options).

You can always disable UAC if you wish to take the risks you used to run in
Windows XP (e.g if you feel the benefits do not outweight the
inconveniences).

However I would give it a couple of weeks before you do disable it. Once you
have your machine configured, apps installed etc, the UAC prompts tend to go
away.

Cheers
Ken

"Ken Renwick" <ken RemoveThis @nospamrdsweb.co.uk> wrote in message
news:uUDuAWPgHHA.5052@TK2MSFTNGP05.phx.gbl...
> Thanks guys
>
> I actually managed to do it by opening the command prompt as administrator
> and typing it manually
>
> Best thing is, problem solved
>
> I cannot believe that we have to jump through hoops like this to continue
> the functionality we took for granted in Windows XP Pro
>
> Ken
>
> "Bernard Cheah [MVP]" <qbernard RemoveThis @hotmail.com.discuss> wrote in message
> news:uHT$TtMgHHA.4552@TK2MSFTNGP04.phx.gbl...
>> Yes, this required administrator access.
>>
>> --
>> Regards,
>> Bernard Cheah
>> http://www.iis.net/
>> http://www.iis-resources.com/
>> http://msmvps.com/blogs/bernard/
>>
>>
>> "Ken Schaefer" <kenREMOVE RemoveThis @THISadOpenStatic.com> wrote in message
>> news:ugqGa$IgHHA.4536@TK2MSFTNGP04.phx.gbl...
>>> Hi,
>>>
>>> You need to elevate your privileges to be able to open
>>> applicationHost.config. Right-click on Notepad.exe and choose "Run as
>>> Administrator". Then you can open/amend applicationHost.config.
>>>
>>> Cheers
>>> Ken
>>>
>>> "Ken Renwick" <ken RemoveThis @nospamrdsweb.co.uk> wrote in message
>>> news:eKvE1vCgHHA.4936@TK2MSFTNGP04.phx.gbl...
>>>> Hi
>>>>
>>>> I have exactly the same problem and am trying to take your advice.
>>>> Problem is the MS Help Note says you have to amend the
>>>> "applicationHost.config" file.
>>>> I've found the file but I can't open it. All I get is access is denied.
>>>> I'm an administrator so I've no idea what to do next. Can you help
>>>> please?
>>>>
>>>> Incidentally, I've already tried the "Resolution" part of the Technote
>>>> and that hasn't worked.
>>>>
>>>> Classic ASP works as in <%=Now%> but no database connection.
>>>>
>>>> Ken
>>>>
>>>> "Bernard Cheah [MVP]" <qbernard RemoveThis @hotmail.com.discuss> wrote in message
>>>> news:uHB5l%23%23fHHA.3676@TK2MSFTNGP05.phx.gbl...
>>>>> Try
>>>>> Error message when you request an ASP page that connects to an Access
>>>>> database in IIS 7.0: "Microsoft JET Database Engine error '80004005'"
>>>>> http://support.microsoft.com/?id=926939
>>>>>
>>>>> look at the workaround section.
>>>>> %windir%\system32\inetsrv\appcmd set appPool
>>>>> "YourAppPool" -processModel.loadUserProfile:false
>>>>>
>>>>> --
>>>>> Regards,
>>>>> Bernard Cheah
>>>>> http://www.iis.net/
>>>>> http://www.iis-resources.com/
>>>>> http://msmvps.com/blogs/bernard/
>>>>>
>>>>>
>>>>> "Sir Benjamin Nunn" <bennunn RemoveThis @depro.co.uk> wrote in message
>>>>> news:58d0e7F1mbgp6U1@mid.individual.net...
>>>>>> Hi there,
>>>>>>
>>>>>> I develop websites on my local machine, and need to work on a site
>>>>>> that connects to an MS Access .MDB file via Classic ASP.
>>>>>>
>>>>>> It worked fine for years under Windows XP Pro, but on Vista Ultimate
>>>>>> (IIS 7) it gives me the unhelpful error message:
>>>>>>
>>>>>> Microsoft JET Database Engine error '80004005' Unspecified error
>>>>>>
>>>>>> I've found a lot of 'solutions' online, none of which seem to address
>>>>>> my specific problem. I needed to enable permissions on the folder for
>>>>>> the Internet Guest User Account, which made no difference.
>>>>>>
>>>>>> If anyone has any ideas for how to get this to work that would be
>>>>>> great.
>>>>>>
>>>>>> For now I'm going to set up an XP partition to do work on this, but
>>>>>> that's hardly a long-term solution.
>>>>>>
>>>>>> BTN
>>>>>
>>>>>
>>>>
>>>
>>
>>
>
 >> Stay informed about: IIS7/Vista Access database 

No Ken, that's not what I'm complaining about.

I'm a web developer moving from XP Pro to Vista.

The minimum that I would expect is that I can continue to locally service
and test sites using classic Asp.
Instead I find that I'm faced with extremely unhelpful error messages on
pages that have been functioning without error for years.
I then have to spend ages "Googling" until I find an obscure solution that
I'm expected to manually install and which may or may not make my system
less secure.

It is clear from other posts that I am not alone and as more and more
developers migrate to Vista the problem is going to occur more and more
often.

Either MS should publicise this much more widely or a fix should urgently be
added and installed via Windows update.

<End of rant />

Ken

"Ken Schaefer" <kenREMOVE.DeleteThis@THISadOpenStatic.com> wrote in message
news:uwAKxHkgHHA.1312@TK2MSFTNGP03.phx.gbl...
> It stops potentially malicious code doing what you just did interactively
> (namely changing/altering critical system configuration options).
>
> You can always disable UAC if you wish to take the risks you used to run
> in Windows XP (e.g if you feel the benefits do not outweight the
> inconveniences).
>
> However I would give it a couple of weeks before you do disable it. Once
> you have your machine configured, apps installed etc, the UAC prompts tend
> to go away.
>
> Cheers
> Ken
>
> "Ken Renwick" <ken.DeleteThis@nospamrdsweb.co.uk> wrote in message
> news:uUDuAWPgHHA.5052@TK2MSFTNGP05.phx.gbl...
>> Thanks guys
>>
>> I actually managed to do it by opening the command prompt as
>> administrator and typing it manually
>>
>> Best thing is, problem solved
>>
>> I cannot believe that we have to jump through hoops like this to continue
>> the functionality we took for granted in Windows XP Pro
>>
>> Ken
>>
>> "Bernard Cheah [MVP]" <qbernard.DeleteThis@hotmail.com.discuss> wrote in message
>> news:uHT$TtMgHHA.4552@TK2MSFTNGP04.phx.gbl...
>>> Yes, this required administrator access.
>>>
>>> --
>>> Regards,
>>> Bernard Cheah
>>> http://www.iis.net/
>>> http://www.iis-resources.com/
>>> http://msmvps.com/blogs/bernard/
>>>
>>>
>>> "Ken Schaefer" <kenREMOVE.DeleteThis@THISadOpenStatic.com> wrote in message
>>> news:ugqGa$IgHHA.4536@TK2MSFTNGP04.phx.gbl...
>>>> Hi,
>>>>
>>>> You need to elevate your privileges to be able to open
>>>> applicationHost.config. Right-click on Notepad.exe and choose "Run as
>>>> Administrator". Then you can open/amend applicationHost.config.
>>>>
>>>> Cheers
>>>> Ken
>>>>
>>>> "Ken Renwick" <ken.DeleteThis@nospamrdsweb.co.uk> wrote in message
>>>> news:eKvE1vCgHHA.4936@TK2MSFTNGP04.phx.gbl...
>>>>> Hi
>>>>>
>>>>> I have exactly the same problem and am trying to take your advice.
>>>>> Problem is the MS Help Note says you have to amend the
>>>>> "applicationHost.config" file.
>>>>> I've found the file but I can't open it. All I get is access is
>>>>> denied.
>>>>> I'm an administrator so I've no idea what to do next. Can you help
>>>>> please?
>>>>>
>>>>> Incidentally, I've already tried the "Resolution" part of the Technote
>>>>> and that hasn't worked.
>>>>>
>>>>> Classic ASP works as in <%=Now%> but no database connection.
>>>>>
>>>>> Ken
>>>>>
>>>>> "Bernard Cheah [MVP]" <qbernard.DeleteThis@hotmail.com.discuss> wrote in message
>>>>> news:uHB5l%23%23fHHA.3676@TK2MSFTNGP05.phx.gbl...
>>>>>> Try
>>>>>> Error message when you request an ASP page that connects to an Access
>>>>>> database in IIS 7.0: "Microsoft JET Database Engine error '80004005'"
>>>>>> http://support.microsoft.com/?id=926939
>>>>>>
>>>>>> look at the workaround section.
>>>>>> %windir%\system32\inetsrv\appcmd set appPool
>>>>>> "YourAppPool" -processModel.loadUserProfile:false
>>>>>>
>>>>>> --
>>>>>> Regards,
>>>>>> Bernard Cheah
>>>>>> http://www.iis.net/
>>>>>> http://www.iis-resources.com/
>>>>>> http://msmvps.com/blogs/bernard/
>>>>>>
>>>>>>
>>>>>> "Sir Benjamin Nunn" <bennunn.DeleteThis@depro.co.uk> wrote in message
>>>>>> news:58d0e7F1mbgp6U1@mid.individual.net...
>>>>>>> Hi there,
>>>>>>>
>>>>>>> I develop websites on my local machine, and need to work on a site
>>>>>>> that connects to an MS Access .MDB file via Classic ASP.
>>>>>>>
>>>>>>> It worked fine for years under Windows XP Pro, but on Vista Ultimate
>>>>>>> (IIS 7) it gives me the unhelpful error message:
>>>>>>>
>>>>>>> Microsoft JET Database Engine error '80004005' Unspecified error
>>>>>>>
>>>>>>> I've found a lot of 'solutions' online, none of which seem to
>>>>>>> address my specific problem. I needed to enable permissions on the
>>>>>>> folder for the Internet Guest User Account, which made no
>>>>>>> difference.
>>>>>>>
>>>>>>> If anyone has any ideas for how to get this to work that would be
>>>>>>> great.
>>>>>>>
>>>>>>> For now I'm going to set up an XP partition to do work on this, but
>>>>>>> that's hardly a long-term solution.
>>>>>>>
>>>>>>> BTN
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
 >> Stay informed about: IIS7/Vista Access database 

"Bernard Cheah [MVP]" <qbernard DeleteThis @hotmail.com.discuss> wrote in message
news:uHB5l%23%23fHHA.3676@TK2MSFTNGP05.phx.gbl...
> Try
> Error message when you request an ASP page that connects to an Access
> database in IIS 7.0: "Microsoft JET Database Engine error '80004005'"
> http://support.microsoft.com/?id=926939
>
> look at the workaround section.
> %windir%\system32\inetsrv\appcmd set appPool
> "YourAppPool" -processModel.loadUserProfile:false


I'm not sure what my apppool is! How do I find this out? There was nothing
obvious in IIS help.

BTN
 >> Stay informed about: IIS7/Vista Access database 

"Ken Renwick" <ken DeleteThis @nospamrdsweb.co.uk> wrote in message
news:%23DOVCCngHHA.392@TK2MSFTNGP06.phx.gbl...
> No Ken, that's not what I'm complaining about.
>
> I'm a web developer moving from XP Pro to Vista.
>
> The minimum that I would expect is that I can continue to locally service
> and test sites using classic Asp.

You can do that

> Instead I find that I'm faced with extremely unhelpful error messages on
> pages that have been functioning without error for years.
> I then have to spend ages "Googling" until I find an obscure solution that
> I'm expected to manually install and which may or may not make my system
> less secure.

Fair enough.

> It is clear from other posts that I am not alone and as more and more
> developers migrate to Vista the problem is going to occur more and more
> often.

Probably not. ASP is deprecated. There is next to no new ASP development
occuring out there - only maintenance of existing ASP code. Pretty much
everyone has moved to ASP.NET now.

> Either MS should publicise this much more widely or a fix should urgently
> be added and installed via Windows update.

What fix? There is an issue - you need to make a configuration change. There
are instructions on how to do this in the KB article.

Cheers
Ken



> <End of rant />
>
> Ken
>
> "Ken Schaefer" <kenREMOVE DeleteThis @THISadOpenStatic.com> wrote in message
> news:uwAKxHkgHHA.1312@TK2MSFTNGP03.phx.gbl...
>> It stops potentially malicious code doing what you just did interactively
>> (namely changing/altering critical system configuration options).
>>
>> You can always disable UAC if you wish to take the risks you used to run
>> in Windows XP (e.g if you feel the benefits do not outweight the
>> inconveniences).
>>
>> However I would give it a couple of weeks before you do disable it. Once
>> you have your machine configured, apps installed etc, the UAC prompts
>> tend to go away.
>>
>> Cheers
>> Ken
>>
>> "Ken Renwick" <ken DeleteThis @nospamrdsweb.co.uk> wrote in message
>> news:uUDuAWPgHHA.5052@TK2MSFTNGP05.phx.gbl...
>>> Thanks guys
>>>
>>> I actually managed to do it by opening the command prompt as
>>> administrator and typing it manually
>>>
>>> Best thing is, problem solved
>>>
>>> I cannot believe that we have to jump through hoops like this to
>>> continue the functionality we took for granted in Windows XP Pro
>>>
>>> Ken
>>>
>>> "Bernard Cheah [MVP]" <qbernard DeleteThis @hotmail.com.discuss> wrote in message
>>> news:uHT$TtMgHHA.4552@TK2MSFTNGP04.phx.gbl...
>>>> Yes, this required administrator access.
>>>>
>>>> --
>>>> Regards,
>>>> Bernard Cheah
>>>> http://www.iis.net/
>>>> http://www.iis-resources.com/
>>>> http://msmvps.com/blogs/bernard/
>>>>
>>>>
>>>> "Ken Schaefer" <kenREMOVE DeleteThis @THISadOpenStatic.com> wrote in message
>>>> news:ugqGa$IgHHA.4536@TK2MSFTNGP04.phx.gbl...
>>>>> Hi,
>>>>>
>>>>> You need to elevate your privileges to be able to open
>>>>> applicationHost.config. Right-click on Notepad.exe and choose "Run as
>>>>> Administrator". Then you can open/amend applicationHost.config.
>>>>>
>>>>> Cheers
>>>>> Ken
>>>>>
>>>>> "Ken Renwick" <ken DeleteThis @nospamrdsweb.co.uk> wrote in message
>>>>> news:eKvE1vCgHHA.4936@TK2MSFTNGP04.phx.gbl...
>>>>>> Hi
>>>>>>
>>>>>> I have exactly the same problem and am trying to take your advice.
>>>>>> Problem is the MS Help Note says you have to amend the
>>>>>> "applicationHost.config" file.
>>>>>> I've found the file but I can't open it. All I get is access is
>>>>>> denied.
>>>>>> I'm an administrator so I've no idea what to do next. Can you help
>>>>>> please?
>>>>>>
>>>>>> Incidentally, I've already tried the "Resolution" part of the
>>>>>> Technote and that hasn't worked.
>>>>>>
>>>>>> Classic ASP works as in <%=Now%> but no database connection.
>>>>>>
>>>>>> Ken
>>>>>>
>>>>>> "Bernard Cheah [MVP]" <qbernard DeleteThis @hotmail.com.discuss> wrote in message
>>>>>> news:uHB5l%23%23fHHA.3676@TK2MSFTNGP05.phx.gbl...
>>>>>>> Try
>>>>>>> Error message when you request an ASP page that connects to an
>>>>>>> Access database in IIS 7.0: "Microsoft JET Database Engine error
>>>>>>> '80004005'"
>>>>>>> http://support.microsoft.com/?id=926939
>>>>>>>
>>>>>>> look at the workaround section.
>>>>>>> %windir%\system32\inetsrv\appcmd set appPool
>>>>>>> "YourAppPool" -processModel.loadUserProfile:false
>>>>>>>
>>>>>>> --
>>>>>>> Regards,
>>>>>>> Bernard Cheah
>>>>>>> http://www.iis.net/
>>>>>>> http://www.iis-resources.com/
>>>>>>> http://msmvps.com/blogs/bernard/
>>>>>>>
>>>>>>>
>>>>>>> "Sir Benjamin Nunn" <bennunn DeleteThis @depro.co.uk> wrote in message
>>>>>>> news:58d0e7F1mbgp6U1@mid.individual.net...
>>>>>>>> Hi there,
>>>>>>>>
>>>>>>>> I develop websites on my local machine, and need to work on a site
>>>>>>>> that connects to an MS Access .MDB file via Classic ASP.
>>>>>>>>
>>>>>>>> It worked fine for years under Windows XP Pro, but on Vista
>>>>>>>> Ultimate (IIS 7) it gives me the unhelpful error message:
>>>>>>>>
>>>>>>>> Microsoft JET Database Engine error '80004005' Unspecified error
>>>>>>>>
>>>>>>>> I've found a lot of 'solutions' online, none of which seem to
>>>>>>>> address my specific problem. I needed to enable permissions on the
>>>>>>>> folder for the Internet Guest User Account, which made no
>>>>>>>> difference.
>>>>>>>>
>>>>>>>> If anyone has any ideas for how to get this to work that would be
>>>>>>>> great.
>>>>>>>>
>>>>>>>> For now I'm going to set up an XP partition to do work on this, but
>>>>>>>> that's hardly a long-term solution.
>>>>>>>>
>>>>>>>> BTN
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>
 >> Stay informed about: IIS7/Vista Access database 

> Probably not. ASP is deprecated.

No it isn't

Quote from Scott Guthrie - "Classic ASP ships with Windows, and so is
covered by the standard Windows support model (10 years from the date the OS
ships). ASP is included in Longhorn Server, and there are no plans to remove
it in the future. This means it will be supported until at least 2017 - but
likely quite a bit longer."

Ken




"Ken Schaefer" <kenREMOVE.DeleteThis@THISadOpenStatic.com> wrote in message
news:Ou1tuFUhHHA.4924@TK2MSFTNGP06.phx.gbl...
> "Ken Renwick" <ken.DeleteThis@nospamrdsweb.co.uk> wrote in message
> news:%23DOVCCngHHA.392@TK2MSFTNGP06.phx.gbl...
>> No Ken, that's not what I'm complaining about.
>>
>> I'm a web developer moving from XP Pro to Vista.
>>
>> The minimum that I would expect is that I can continue to locally service
>> and test sites using classic Asp.
>
> You can do that
>
>> Instead I find that I'm faced with extremely unhelpful error messages on
>> pages that have been functioning without error for years.
>> I then have to spend ages "Googling" until I find an obscure solution
>> that I'm expected to manually install and which may or may not make my
>> system less secure.
>
> Fair enough.
>
>> It is clear from other posts that I am not alone and as more and more
>> developers migrate to Vista the problem is going to occur more and more
>> often.
>
> Probably not. ASP is deprecated. There is next to no new ASP development
> occuring out there - only maintenance of existing ASP code. Pretty much
> everyone has moved to ASP.NET now.
>
>> Either MS should publicise this much more widely or a fix should urgently
>> be added and installed via Windows update.
>
> What fix? There is an issue - you need to make a configuration change.
> There are instructions on how to do this in the KB article.
>
> Cheers
> Ken
>
>
>
>> <End of rant />
>>
>> Ken
>>
>> "Ken Schaefer" <kenREMOVE.DeleteThis@THISadOpenStatic.com> wrote in message
>> news:uwAKxHkgHHA.1312@TK2MSFTNGP03.phx.gbl...
>>> It stops potentially malicious code doing what you just did
>>> interactively (namely changing/altering critical system configuration
>>> options).
>>>
>>> You can always disable UAC if you wish to take the risks you used to run
>>> in Windows XP (e.g if you feel the benefits do not outweight the
>>> inconveniences).
>>>
>>> However I would give it a couple of weeks before you do disable it. Once
>>> you have your machine configured, apps installed etc, the UAC prompts
>>> tend to go away.
>>>
>>> Cheers
>>> Ken
>>>
>>> "Ken Renwick" <ken.DeleteThis@nospamrdsweb.co.uk> wrote in message
>>> news:uUDuAWPgHHA.5052@TK2MSFTNGP05.phx.gbl...
>>>> Thanks guys
>>>>
>>>> I actually managed to do it by opening the command prompt as
>>>> administrator and typing it manually
>>>>
>>>> Best thing is, problem solved
>>>>
>>>> I cannot believe that we have to jump through hoops like this to
>>>> continue the functionality we took for granted in Windows XP Pro
>>>>
>>>> Ken
>>>>
>>>> "Bernard Cheah [MVP]" <qbernard.DeleteThis@hotmail.com.discuss> wrote in message
>>>> news:uHT$TtMgHHA.4552@TK2MSFTNGP04.phx.gbl...
>>>>> Yes, this required administrator access.
>>>>>
>>>>> --
>>>>> Regards,
>>>>> Bernard Cheah
>>>>> http://www.iis.net/
>>>>> http://www.iis-resources.com/
>>>>> http://msmvps.com/blogs/bernard/
>>>>>
>>>>>
>>>>> "Ken Schaefer" <kenREMOVE.DeleteThis@THISadOpenStatic.com> wrote in message
>>>>> news:ugqGa$IgHHA.4536@TK2MSFTNGP04.phx.gbl...
>>>>>> Hi,
>>>>>>
>>>>>> You need to elevate your privileges to be able to open
>>>>>> applicationHost.config. Right-click on Notepad.exe and choose "Run as
>>>>>> Administrator". Then you can open/amend applicationHost.config.
>>>>>>
>>>>>> Cheers
>>>>>> Ken
>>>>>>
>>>>>> "Ken Renwick" <ken.DeleteThis@nospamrdsweb.co.uk> wrote in message
>>>>>> news:eKvE1vCgHHA.4936@TK2MSFTNGP04.phx.gbl...
>>>>>>> Hi
>>>>>>>
>>>>>>> I have exactly the same problem and am trying to take your advice.
>>>>>>> Problem is the MS Help Note says you have to amend the
>>>>>>> "applicationHost.config" file.
>>>>>>> I've found the file but I can't open it. All I get is access is
>>>>>>> denied.
>>>>>>> I'm an administrator so I've no idea what to do next. Can you help
>>>>>>> please?
>>>>>>>
>>>>>>> Incidentally, I've already tried the "Resolution" part of the
>>>>>>> Technote and that hasn't worked.
>>>>>>>
>>>>>>> Classic ASP works as in <%=Now%> but no database connection.
>>>>>>>
>>>>>>> Ken
>>>>>>>
>>>>>>> "Bernard Cheah [MVP]" <qbernard.DeleteThis@hotmail.com.discuss> wrote in
>>>>>>> message news:uHB5l%23%23fHHA.3676@TK2MSFTNGP05.phx.gbl...
>>>>>>>> Try
>>>>>>>> Error message when you request an ASP page that connects to an
>>>>>>>> Access database in IIS 7.0: "Microsoft JET Database Engine error
>>>>>>>> '80004005'"
>>>>>>>> http://support.microsoft.com/?id=926939
>>>>>>>>
>>>>>>>> look at the workaround section.
>>>>>>>> %windir%\system32\inetsrv\appcmd set appPool
>>>>>>>> "YourAppPool" -processModel.loadUserProfile:false
>>>>>>>>
>>>>>>>> --
>>>>>>>> Regards,
>>>>>>>> Bernard Cheah
>>>>>>>> http://www.iis.net/
>>>>>>>> http://www.iis-resources.com/
>>>>>>>> http://msmvps.com/blogs/bernard/
>>>>>>>>
>>>>>>>>
>>>>>>>> "Sir Benjamin Nunn" <bennunn.DeleteThis@depro.co.uk> wrote in message
>>>>>>>> news:58d0e7F1mbgp6U1@mid.individual.net...
>>>>>>>>> Hi there,
>>>>>>>>>
>>>>>>>>> I develop websites on my local machine, and need to work on a site
>>>>>>>>> that connects to an MS Access .MDB file via Classic ASP.
>>>>>>>>>
>>>>>>>>> It worked fine for years under Windows XP Pro, but on Vista
>>>>>>>>> Ultimate (IIS 7) it gives me the unhelpful error message:
>>>>>>>>>
>>>>>>>>> Microsoft JET Database Engine error '80004005' Unspecified error
>>>>>>>>>
>>>>>>>>> I've found a lot of 'solutions' online, none of which seem to
>>>>>>>>> address my specific problem. I needed to enable permissions on the
>>>>>>>>> folder for the Internet Guest User Account, which made no
>>>>>>>>> difference.
>>>>>>>>>
>>>>>>>>> If anyone has any ideas for how to get this to work that would be
>>>>>>>>> great.
>>>>>>>>>
>>>>>>>>> For now I'm going to set up an XP partition to do work on this,
>>>>>>>>> but that's hardly a long-term solution.
>>>>>>>>>
>>>>>>>>> BTN
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>
 >> Stay informed about: IIS7/Vista Access database