When this line executes on a database on my server, I get the error shown below:
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=F:/OFF-PRG/fbcdata.mdb");
Error returned:
"...It is already opened exclusively by another user, or you need permission to view its data..."
Answer found on the web:
This can happen if Apache can't write the Jet lock file because IUSR_MACHINE doesn't have write permissions to the directory containing the .mdb file.
I found this as an answer to the problem, but not sure how to tell if Apache can create this lock or has the correct permissions. I can use MSAccess to open and manipulate the db at its network location. Also, when I copy this same db to my local drive, the script opens the db and queries it perfectly. So it does sound like a permissions problem.
The security properties on the F: drive are set to allow any/all access for "Domain Users".
The security properties for the folder "OFF-PRG" are set to allow any/all access for "Everyone"
The security properties for the file "fbcdata.mdb" are set to allow any/all access for "Everyone". So, it looks like anyone/everyone should have any type of access to the db.
Can anyone point me in the right direction for a solution?
tia,
flynn
