ODBC and subweb with anonymous browsing disabled problem

[Michele]

Hi,

I have a FrontPage 2002 web, which has a subweb with anonymous
browsing disabled, requiring authentication.

I have a System DSN for an Access database for the same site. I'm
also using ASP and VBScript, just FYI.

All calls to my database work just great until I visit the subweb and
authenticate. Then, all database calls fail with the following error:

The Microsoft Jet database engine cannot open the file '(unknown)'. It
is already opened exclusively by another user, or you need permission
to view its data.


If I clear cache or delete temporary internet files, I can then access
the database again.

My theory is this happens because IUSR has rights to the database
directory, and after authenticating for the subweb, the calls are not
from IUSR anymore, but from the authenticated user, which doesn't have
rights. Thoughts? Suggestions?

I wonder if there is a way to become IUSR again after visiting the
subweb?

Thanks for any help.

-Michele

 

[Thomas A. Rowe]

Have you considered using ASP/VBscript to control access to the subweb, instead of the OS?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================