Check NTFS permissions on the server. The user account context that you are
running ASP pages in need to be able to:
a) alter the database
b) create and destory the .ldb lockfile

If you are allowing anonymous access, the then the user context is either
IUSR_<machinenane> or IWAM_<machinename> depending on the application
isolation level.

Also, don't keep the database open in other applications (eg Access, or
Visual Interdev), as you may have an exclusive lock on a table (eg if you
have the table open in Design mode).

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Todd Schuman" <todd_schuman@h...>
Subject: [access_asp] Can't Open Database File


: I am working in Windows 2000 with admin access and creating ASP code to
: pull info from an Access 2000 DB.  I was able to access the DB fine for a
: while but now for some reason I can not.  I keep getting the following
: error message:
:
: Microsoft JET Database Engine (0x80004005)
: The Microsoft Jet database engine cannot open the
: file 'C:\inetpub\wwwroot\Joyce\Milestones.mdb'. It is already opened
: exclusively by another user, or you need permission to view its data.
:
: The path is correct and it was working before.  Here is my connection
: string:
:
: Dim connStr
: connStr ="Provider=Microsoft.Jet.OLEDB.4.0;Data
: Source=C:\inetpub\wwwroot\Joyce\Milestones.mdb;"
:
: 'Establish Connection
: Dim Conn
: Set Conn = Server.CreateObject("ADODB.Connection")
: Conn.Open connStr
:
: Anyone ever run into this problem.  I cant seem to figure it out.