1. Give IUSR_SCOTLAND at least "Write" permission to the directory the MDB file is in. I believe this is necessary because the Access component (that accesses the database) makes a temporary file in the directory, or because the LockFile{Ex}() primitives requires certain permissions on the directory.

  2. Give IUSR_SCOTLAND Read/Write permission on the MDB file itself.

  3. Use the following ASP code (VBScript in this example):
    <%
    Set cnn = Server.CreateObject( "ADODB.Connection" )
    ' Convert path relative to current directory to full path
    strMDBPath = Server.MapPath( "mydatabase.mdb" )Tools Page | CS169 Home ]

    This page maintained by Sam Madden. Last update 3/8/2000.