ASP.net OLE DB --> MS Access network

  • Thread starter Thread starter js
  • Start date Start date
J

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
 
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.
Click to expand...

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.
Click to expand...

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.
 
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)
Click to expand...


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.aspx?scid=kb;en-us;316675

http://support.microsoft.com/default.aspx?scid=kb;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.
 
Back
Top