ODBC Error while accessing MS Access

[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

 

[Rob Schneider]

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

Best to discuss this on the ASP and/or ODBC newsgroups ... Experts are
there.

That being said ... since you are using ASP, I presume you are doing
this access via a web server on your machine? Accordingly, look
carefully at the permissions you have setup. Surely it is the web
server's ID that is accessing the database, *not* your ID, and surely
you don't want to grant access to *everyone*. Check also how you have
setup the ODBC connection. Maybe you configured it to have exclusive
access. I presume it worked at one time. Therefore, what changed?