ODBC Error while accessing Access from ASP

ODBC Error while accessing Access from ASP

Post by Sudhakar S » Sat, 20 Sep 2003 15:01:47


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
 
 
 

ODBC Error while accessing Access from ASP

Post by Douglas J. » Sat, 20 Sep 2003 18:36:27

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).