Re: Error 500

From: Susan Hayden [MS] (shayden@online.microsoft.com)
Date: 07/05/02 

From: shayden@online.microsoft.com (Susan Hayden [MS])
Date: Fri, 05 Jul 2002 19:45:14 GMT

Darm,

You wrote:
I an running IIS 5.1 in XP, I am currently trying to
develop a small intranet that will use MS Access DB to
store/retrieve data. The site works fine until I try and
write anything into the DB, I've added the script I'm
using below (this script works fine on PWS running on
Win98):

The script works on Win98 because you are running into a permissions issue.
An access database requires that everyone have full control of the
directory containing the mdb file , this is because Access tracks users
through a .ldb file created in the same directory, first user in creates
the file, last user out deleles it, if the .ldb file can not be created the
database will be opened read only.
Susan Hayden
IIS Newsgroup Support

Please do not send email directly to this alias. This is our online account
name for newsgroup participation only.

This posting is provided “AS IS” with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Please remember to subscribe to our security bulletins at
<http://www.microsoft.com/technet/security/notify.asp>

Relevant Pages

  • RE: Access database placed in a state...
    ... the back end folder does not require delete rights -- ... it will run just fine without it, though the LDB file will never be ... The usual reason for doing this is to prevent users from ... someone with delete permissions can take care of it. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Folder security set up
    ... Do we need only give full rights to the .LDB file and read-only on ... If your intention is for all users to have read only rights then you can just ... make the MDB and folder be read only for all users. ... If a user with edit rights opens the file first then all read only users are ...
    (microsoft.public.access.security)
  • Re: My network database tells users its read only when it isnt.why?
    ... > In order to affect the data in an access database, ... > read/write permissions on it. ... > creates the .ldb file when the database is open. ... Which is why users also need create/delete permissions on the folder, ...
    (microsoft.public.access.security)
  • Re: updating a access Database Record
    ... If it is an ASP.NET app you may even need to edit the machine.config file. ... Do I need to share and allow changing the folder where my ... > When you write to an access database that user has to create an ldb file ...
    (microsoft.public.dotnet.languages.vb)
  • Re: db connection
    ... I am not sure that just because there is *.ldb file still in your folder ... is this a webapp or winform? ... >I wrote a program in c# and oledb for my access database. ...
    (microsoft.public.dotnet.framework.aspnet)