ASP.net OLE DB --> MS Access network

[js]

ERROR:
The Microsoft Jet database engine cannot open the
file...It is already opened exclusively by another user,
or you need permission to view its data.

I have
<identity impersonate="true" />

setup for network:
Client --> IIS Server --> Network Location for Access DB.

I know the user has rights to the access DB, it works if
the client executes the asp.net page from the iis server.
so i know it has something to do with the credentials.

i guess they are getting lost along the way? too many
hops?

how would i make this work?

THANKS,
Jerry

[Steven Wood]

> I know the user has rights to the access DB, it works if

the client executes the asp.net page from the iis server.
so i know it has something to do with the credentials.
You say that the connection works through ASP.NET. In what
circumstances are you getting the connection error?
ERROR:
The Microsoft Jet database engine cannot open the
file...It is already opened exclusively by another user,
or you need permission to view its data.

An error will occur if the .mdb file is already open in Access.

Please supply more information and I'll see if I can help.

---
Steven Wood.

[JS]

Actually i have tested with the Access db open.

let me clarify:

No Error with this setup:
NOTE: IIS server and client are same machine with this
test.
IIS Server (A)
Client Machine (A) (web browser)
SAN (C) (location of access db)

Version that creates error:
IIS server (A)
Client Machine (B) (web browser)
SAN (C) (location of access db)

With the above mentioned setup, I receive the error listed
below

ERROR:
The Microsoft Jet database engine cannot open the
file...It is already opened exclusively by another user, or you need permission to view its data.
When using the first setup, I was worried whether or not
the process would be affected by having someone open the
Access database, so I tested that as well. No error with
the FIRST example.

Thanks for your help.
JS

-----Original Message-----

I know the user has rights to the access DB, it works

if the client executes the asp.net page from the iis server. so i know it has something to do with the credentials.

You say that the connection works through ASP.NET. In

whatcircumstances are you getting the connection error?

ERROR:
The Microsoft Jet database engine cannot open the
file...It is already opened exclusively by another user, or you need permission to view its data.
An error will occur if the .mdb file is already open in

Access.
Please supply more information and I'll see if I can help.

---
Steven Wood.
.

[Steven Wood]

Hi JS.

let me clarify:

No Error with this setup:
NOTE: IIS server and client are same machine with this
test.
IIS Server (A)
Client Machine (A) (web browser)
SAN (C) (location of access db)

Version that creates error:
IIS server (A)
Client Machine (B) (web browser)
SAN (C) (location of access db)

I'm confused (or possibly just being a bit dim) because it appears that your
IIS Server (A) and Access database (C) are always on different machines. If
your web application is connecting to the database, then it should not
matter where the client is. Is the web application connecting to the Access
database using a connection string?

Do the following links help in any way?

http://support.microsoft.com/default...b;en-us;316675

http://support.microsoft.com/default...b;en-us;308278

(granted the second one is for VB.NET, but should be easy enough to
translate to C#).

Let me know if you need anything else.

---
Steven Wood