Upgrade to IIS 6 broke Access DB

[Walt]

We upgraded to IIS 6.0 along with Windows Server 2003 and
all of our Access Databases are not working. I believe
the connections are not working because you can open them
in access. These are access XP. Any ideas, We upgraded
from IIS 5.0 and 2000 Server

[Tom Kaminski [MVP]]

"Walt" <anonymous@discussions.microsoft.com> wrote in message
news:462401c42bc0$bb565910$a401280a@phx.gbl...

> We upgraded to IIS 6.0 along with Windows Server 2003 and
> all of our Access Databases are not working. I believe
> the connections are not working because you can open them
> in access. These are access XP. Any ideas, We upgraded
> from IIS 5.0 and 2000 Server

FAQ and a well-known bug:
[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;838306[/url]

--
Tom Kaminski IIS MVP
[url]http://www.iistoolshed.com/[/url] - tools, scripts, and utilities for running IIS
[url]http://mvp.support.microsoft.com/[/url]
[url]http://www.microsoft.com/windowsserver2003/community/centers/iis/[/url]

[Ray at]

What does "are not working" mean? Do you get an error? What is it?

Ray at work

"Walt" <anonymous@discussions.microsoft.com> wrote in message
news:462401c42bc0$bb565910$a401280a@phx.gbl...

> We upgraded to IIS 6.0 along with Windows Server 2003 and
> all of our Access Databases are not working. I believe
> the connections are not working because you can open them
> in access. These are access XP. Any ideas, We upgraded
> from IIS 5.0 and 2000 Server

[Jeff Cochran]

On Mon, 26 Apr 2004 12:00:24 -0700, "Walt"
<anonymous@discussions.microsoft.com> wrote:

>We upgraded to IIS 6.0 along with Windows Server 2003 and
>all of our Access Databases are not working. I believe
>the connections are not working because you can open them
>in access. These are access XP. Any ideas, We upgraded
>from IIS 5.0 and 2000 Server

In addition to Tom's answer, if you're actually seeing an ASP error
instead of the Jet bug, it may be you didn't enable ASP in IIS6. See:

How To: Enable ASP on IIS6:
[url]http://www.visualwin.com/ASP/[/url]
[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;315122[/url]

Jeff

[CJ]

Try converting the access databse to a newer version of access.
Like access 2002 or newer. 200 is probably ok as well.

If it is a 97 version the odbc drivers might not like it.
The odbc drivers might have got updated when you went to 2003



"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
news:409268b9.440708705@msnews.microsoft.com...

> On Mon, 26 Apr 2004 12:00:24 -0700, "Walt"
> <anonymous@discussions.microsoft.com> wrote:
>

> >We upgraded to IIS 6.0 along with Windows Server 2003 and
> >all of our Access Databases are not working. I believe
> >the connections are not working because you can open them
> >in access. These are access XP. Any ideas, We upgraded
> >from IIS 5.0 and 2000 Server

>
> In addition to Tom's answer, if you're actually seeing an ASP error
> instead of the Jet bug, it may be you didn't enable ASP in IIS6. See:
>
> How To: Enable ASP on IIS6:
> [url]http://www.visualwin.com/ASP/[/url]
> [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;315122[/url]
>
> Jeff