Re: MS Access on IIS 5.0

From: Robin (anonymous_at_discussions.microsoft.com)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 09:00:28 -0700

Its working like a charm!

Thanks again for all your help!

>-----Original Message-----
>On Wed, 16 Jun 2004 02:56:21 -0700, "Robin"
><anonymous@discussions.microsoft.com> wrote:
>
>>I do in fact have an include file which will save me
from
>>having to modify each page. I know this is another
>>problem which I have to fix but I think I can manage
this
>>myself *fingers crossed*
>>
>>I moved the databases to another folder but now I can't
>>get the site to pull the info out of them or post into
>>it. Page simply displays blank fields where the data
>>should populate!?!?!
>
>When you move the file, you need to change the
connection string to
>match the new location.
>
>>What code do I need in the include file? I'd like to
>>avoid configuring any DSN.
>>Currently the code looks something like this:
>><% Session("databasepath")
>>= "D:\Inetpub\wwwroot\sitename\data\databasename.mdb" %>
>>Do I leave it this way or change it? If I leave it how
>>do I get the database's to work now that I've moved
them!
>
>Change this path to wherever you moved the file. If
it's moved to
>D:\Databases\Sitename\Database.mdb for example, replace
the path in
>your code with the correct path.
>
>Jeff
>
>>Thanks again for your help!!!
>>Very appreciative!
>>
>>
>>>Normally a designer would use an include file for the
>>database
>>>connections, but some code this into every page and
>>unfortunately
>>>you'd need to change those pages individually. As for
>>permissions,
>>>usually just the system account needs access, but if
the
>>folder is
>>>outside that defined in IIS it can't be accessed by a
>>HTTP request to
>>>download it, no matter what security the folder/file
>>has. Also use
>>>URLScan if you're on IIS5 to defeat parent paths or
>>directory
>>>traversing, and make sure the server has current
>>security patches.
>>>
>>>Jeff
>
>.
>

Relevant Pages

  • Re: MS Access on IIS 5.0
    ... >having to modify each page. ... >problem which I have to fix but I think I can manage this ... >I moved the databases to another folder but now I can't ... you need to change the connection string to ...
    (microsoft.public.inetserver.iis.security)
  • Re: ACL To Create and Modify Only New Files?
    ... try using a grant to CreatorOwner ... of Modify on the base folder and below plus a grant to Users ... left is what the ACE means applied to a directory, ...
    (microsoft.public.security)
  • Applying NTFS Folder Permissions
    ... "Giorgio belongs to the Human Resources global group & the 4th Floor Users ... has been granted the Modify permission & the 4th Floor Users group has been ... be able to read the contents of the folder & add files to the folder. ...
    (microsoft.public.cert.exam.mcsa)
  • RE: Applying NTFS Folder Permissions
    ... Giorgio is attempting to access a folder for which the HR group ... > has been granted the Modify permission & the 4th Floor Users group has been ... > granted the Write permission. ... > be able to read the contents of the folder & add files to the folder. ...
    (microsoft.public.cert.exam.mcsa)
  • Re: read and write permission does not delete word ~ files
    ... Ah yes on a file the only diff is delete, on a folder it is delete and deleted ... Based on how Windows apps tend to modify files if you can write and you can ... Joe Richards Microsoft MVP Windows Server Directory Services ... >>In the advanced tab you can specify delete permission instead of giving ...
    (microsoft.public.windows.server.security)