469,313 Members | 2,636 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,313 developers. It's quick & easy.

ASP.NET & Access database

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
Nov 19 '05 #1
3 1234
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

Nov 19 '05 #2
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

Nov 19 '05 #3
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


Nov 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.