Data Access and Transactions |
Setting up a DSN is the first step toward connecting to a database. You also need the correct permissions before you can access data from the Web. If you don’t have these and you try to open an Access database stored on an NTFS file system, you might get the following error:
Microsoft OLE DB provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Access 97 Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
This problem occurs when the anonymous (IUSR_computername) account doesn’t have the necessary permissions for the directory containing the database (.mdb) file. In order to make modifications to the data, the Jet database engine (on which Access is built) needs to create a lock file, a temporary working file in the same directory as the database. If the anonymous user can’t write to this lock file, an error will occur. Make sure that you grant sufficient permission on the database and its directory for the anonymous user account. Also verify that exclusive access and record locking are turned off.