Re: 80004005 Error & File Permissons

That "subfolder" is inside of your web structure. It needs to be outside of
it. That's what I meant by "outside of wwwroot". IIS won't serve the
contents of folders that aren't in the web structure.

You could also map the extension so IIS won't serve it.
Matt K wrote:
Thanks Bob!

I did as you suggested and all works, except the database can be
accessed directly if you know the database name, ie:
www.domain.com/folder/subfolder/database.mdb

I have the database password protected, but up until we added the new
SSL cert, did not have to worry about the database being accessed
simply by calling the url.

Any other suggestions?
Thanks again!!
Matt

"Bob Barrows [MVP]" wrote:

Matt K wrote:
Greetings,

I have a website that access an Access 2003 database on the same
server, different folder. All worked fine until we added a new SSL
Certificate and now I receive the 80004005 "....already in use
or..... permissions...." error.

I can work-around this by giving the .mdb file read/write
permissions
to the IUSR-MachineName account, but this exposes the database to
anyone opening it or downloading it (which we don't want).

I'm using the following connection string:

Set oConn=Server.CreateObject("ADODB.Connection")
filePath = Server.MapPath("\folder\subfolder\dbDatabase.mdb")
oConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+filePath)

Any suggestions on how to allow the pages to access the database
without completely exposing it to the outside?

Thanks in advance!
Matt
Move the file to a folder outside of wwwroot, grant the IUSR account
Modify permissions to the folder containing the database.
--
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"

--
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"


.

Relevant Pages

  • Re: 80004005 Unspecified Error
    ... > the warehouse!) ... Can the database be opened in Access? ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: multiple connections to access DB?
    ... so if the folder the database is in allows read/write for ... read/write permissions. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: question about ASP with ACCESS
    ... and verify that the path produced is the valid path to your database. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: Cannot Update ADO Recordset??
    ... Again, it's a Permissions issue, specifically, a filesystem permissions ... Database or object is read-only. ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: 80004005 Error & File Permissons
    ... I have a website that access an Access 2003 database on the same ... Move the file to a folder outside of wwwroot, grant the IUSR account Modify ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)