ODBC Error while accessing Access from ASP

[Sudhakar Sankar]

Hi,

I am using MS Access as a database in my Windows XP
Professional Edition(SP 1). While connecting to MS Access
from my ASP Page thru' ODBC, i am getting the following
error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access 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

I'm sure that MS Access Database is not opened by any
one/any other application. And, i give the grant to "Every
One" to access the Database File. Still i am getting this
error.

Any idea on this error?


Thanks
Sudhakar Sankar

 

[Douglas J. Steele]

ASP is usually run under the ID IUSR_machinename (where machinename is the
name of the machine). What permission does that ID have on the folder where
the MDB file is located? It needs at least Change (RWXD).