ASP.NET & Access database

[MW de Jager]

I'm having endless problems with gaining access to an Access Database that
sits on a different server. My ASP.NET app cannot gain control. The errror
message I get is:

The Microsoft Jet database engine cannot open the file
'\\Server1\DataFolder\Countries5.mdb'. It is already opened exclusively by
another user, or you need permission to view its data.

I have setup the connection string to have the username = admin and the
password is blank. At design time I can see the data no problem, yet as
soon as the ASP.NET app is running, I get the above error.

Any ideas anyone?

Regards
MW

[srini]

Hi,
I think the info in this link can help you resolve this issue
http://support.microsoft.com/default...;EN-US;q306269
--
The best
srini
http://www.expertszone.com
"MW de Jager" wrote:

I'm having endless problems with gaining access to an Access Database that
sits on a different server. My ASP.NET app cannot gain control. The errror
message I get is:

The Microsoft Jet database engine cannot open the file
'\\Server1\DataFolder\Countries5.mdb'. It is already opened exclusively by
another user, or you need permission to view its data.

I have setup the connection string to have the username = admin and the
password is blank. At design time I can see the data no problem, yet as
soon as the ASP.NET app is running, I get the above error.

Any ideas anyone?

Regards
MW

[Juan T. Llibre]

MW,

There's two types of permissions needed in order to be
able to access data in a database in an external server:

1. database permissions
2. file permissions

re:

I have setup the connection string to have the username = admin
That corresponds to the database permission and is fine that way.

You also need to allow file permission access to
the account under which ASP.NET is running.

i.e.,
your ASP.NET account must have permission to access \\Server1\DataFolder\

Notice that you need read/write permissions assigned for the full folder,
and not just for the database file.


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"MW de Jager" <mw*******@privatemail.me.uk> wrote in message
news:d8**********@ctb-nnrp2.saix.net... I'm having endless problems with gaining access to an Access Database that sits on a
different server. My ASP.NET app cannot gain control. The errror message I get is:

The Microsoft Jet database engine cannot open the file
'\\Server1\DataFolder\Countries5.mdb'. It is already opened exclusively by another user,
or you need permission to view its data.

I have setup the connection string to have the username = admin and the password is
blank. At design time I can see the data no problem, yet as soon as the ASP.NET app is
running, I get the above error.

Any ideas anyone?

Regards
MW

[MW de Jager]

Ok, it's working now. If I open my website on my app server, on which the
access database is, it works fine. If I however run the app local with the
access data on the server (like when you are still coding), then my problems
return with a vengeance.

If I use impersonation with usename="NT AUTHORITY\NETWORK SERVICE" it still
runs ok until I try to open the page that requests the access database. The
above username is what is being used when I run it on the server with no
problems.

Any ideas as to which user name to use or is my problem elsewhere?

Regards
MW
"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:ue**************@TK2MSFTNGP15.phx.gbl...

MW,

There's two types of permissions needed in order to be
able to access data in a database in an external server:

1. database permissions
2. file permissions

re:

I have setup the connection string to have the username = admin

That corresponds to the database permission and is fine that way.

You also need to allow file permission access to
the account under which ASP.NET is running.

i.e.,
your ASP.NET account must have permission to access \\Server1\DataFolder\

Notice that you need read/write permissions assigned for the full folder,
and not just for the database file.


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"MW de Jager" <mw*******@privatemail.me.uk> wrote in message
news:d8**********@ctb-nnrp2.saix.net...

I'm having endless problems with gaining access to an Access Database
that sits on a different server. My ASP.NET app cannot gain control.
The errror message I get is:

The Microsoft Jet database engine cannot open the file
'\\Server1\DataFolder\Countries5.mdb'. It is already opened exclusively
by another user, or you need permission to view its data.

I have setup the connection string to have the username = admin and the
password is blank. At design time I can see the data no problem, yet as
soon as the ASP.NET app is running, I get the above error.

Any ideas anyone?

Regards
MW