473,320 Members | 2,000 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Required rights to connect to access db

Hi all,
On my local pc I have built a webpage which reads data
from a ms-access file. No problem at all. When I place the
files on our intranet-server I receive an error:

System.Data.OleDb.OleDbException: Unspecified error

When I am a member of the domainadmins it works just fine,
so it must be a rights issue. Can anyone tell me what
kind of rights are needed to make this work for all users
in our company?

Thanks,
Paul
Nov 17 '05 #1
5 1354
Have you checked that the directory that holds the MDB file has write
permission for people who are not domain admins? You might want to consider
setting the app permissions to impersonate the logged on user, and allow
write for authenticated users.
--
Regards

John Timney (Microsoft ASP.NET MVP)
----------------------------------------------
<shameless_author_plug>
Professional .NET for Java Developers with C#
ISBN:1-861007-91-4
Professional Windows Forms
ISBN: 1861005547
Professional JSP 2nd Edition
ISBN: 1861004958
Professional JSP
ISBN: 1861003625
Beginning JSP Web Development
ISBN: 1861002092
</shameless_author_plug>
----------------------------------------------

"Paul" <Pa**@nospam.com> wrote in message
news:0d****************************@phx.gbl...
Hi all,
On my local pc I have built a webpage which reads data
from a ms-access file. No problem at all. When I place the
files on our intranet-server I receive an error:

System.Data.OleDb.OleDbException: Unspecified error

When I am a member of the domainadmins it works just fine,
so it must be a rights issue. Can anyone tell me what
kind of rights are needed to make this work for all users
in our company?

Thanks,
Paul

Nov 17 '05 #2
Hi John,
Even when they assign 'full control' rights I still
receive this error.

Does that make any sense to you?

Thanks,
Paul
-----Original Message-----
Have you checked that the directory that holds the MDB file has writepermission for people who are not domain admins? You might want to considersetting the app permissions to impersonate the logged on user, and allowwrite for authenticated users.
--
Regards

John Timney (Microsoft ASP.NET MVP)
----------------------------------------------
<shameless_author_plug>
Professional .NET for Java Developers with C#
ISBN:1-861007-91-4
Professional Windows Forms
ISBN: 1861005547
Professional JSP 2nd Edition
ISBN: 1861004958
Professional JSP
ISBN: 1861003625
Beginning JSP Web Development
ISBN: 1861002092
</shameless_author_plug>
----------------------------------------------

"Paul" <Pa**@nospam.com> wrote in message
news:0d****************************@phx.gbl...
Hi all,
On my local pc I have built a webpage which reads data
from a ms-access file. No problem at all. When I place the files on our intranet-server I receive an error:

System.Data.OleDb.OleDbException: Unspecified error

When I am a member of the domainadmins it works just fine, so it must be a rights issue. Can anyone tell me what
kind of rights are needed to make this work for all users in our company?

Thanks,
Paul

.

Nov 17 '05 #3
Does the aspnet account has rights to that directory?

jayuya
-----Original Message-----
Hi all,
On my local pc I have built a webpage which reads data
from a ms-access file. No problem at all. When I place thefiles on our intranet-server I receive an error:

System.Data.OleDb.OleDbException: Unspecified error

When I am a member of the domainadmins it works just fine,so it must be a rights issue. Can anyone tell me what
kind of rights are needed to make this work for all users
in our company?

Thanks,
Paul
.

Nov 17 '05 #4
Hi John,
They assigned full control to me, no use.
I also tried adding the iusr_machinename/aspnet account
(both change rights). It did not work.

There is no anonymous connection allowed.

Do you have a clue? When I run the application on my w2k
workstation, everybody can acces my app.

Thanx in advance,
Paul
-----Original Message-----
I guess the question is full control for whom - I would start by assigningit to everyone, and allow anonymous connection in IIS, then work out whereyou lose permission to access the DB as you apply restrictions.....
--
Regards

John Timney (Microsoft ASP.NET MVP)
----------------------------------------------
<shameless_author_plug>
Professional .NET for Java Developers with C#
ISBN:1-861007-91-4
Professional Windows Forms
ISBN: 1861005547
Professional JSP 2nd Edition
ISBN: 1861004958
Professional JSP
ISBN: 1861003625
Beginning JSP Web Development
ISBN: 1861002092
</shameless_author_plug>
----------------------------------------------

"Paul" <Pa**@nospam.com> wrote in message
news:00****************************@phx.gbl...
Hi John,
Even when they assign 'full control' rights I still
receive this error.

Does that make any sense to you?

Thanks,
Paul
>-----Original Message-----
>Have you checked that the directory that holds the MDB

file has write
>permission for people who are not domain admins? You

might want to consider
>setting the app permissions to impersonate the logged on
user, and allow
>write for authenticated users.
>--
>Regards
>
>John Timney (Microsoft ASP.NET MVP)
>----------------------------------------------
><shameless_author_plug>
>Professional .NET for Java Developers with C#
> ISBN:1-861007-91-4
>Professional Windows Forms
> ISBN: 1861005547
>Professional JSP 2nd Edition
> ISBN: 1861004958
>Professional JSP
> ISBN: 1861003625
>Beginning JSP Web Development
> ISBN: 1861002092
></shameless_author_plug>
>----------------------------------------------
>
>"Paul" <Pa**@nospam.com> wrote in message
>news:0d****************************@phx.gbl...
>> Hi all,
>> On my local pc I have built a webpage which reads
data >> from a ms-access file. No problem at all. When I place the
>> files on our intranet-server I receive an error:
>>
>> System.Data.OleDb.OleDbException: Unspecified error
>>
>> When I am a member of the domainadmins it works just

fine,
>> so it must be a rights issue. Can anyone tell me

what >> kind of rights are needed to make this work for all

users
>> in our company?
>>
>> Thanks,
>> Paul
>>
>>
>
>
>.
>

.

Nov 17 '05 #5
try giving authenticated user write permission at the file level

--
Regards

John Timney (Microsoft ASP.NET MVP)
----------------------------------------------
<shameless_author_plug>
Professional .NET for Java Developers with C#
ISBN:1-861007-91-4
Professional Windows Forms
ISBN: 1861005547
Professional JSP 2nd Edition
ISBN: 1861004958
Professional JSP
ISBN: 1861003625
Beginning JSP Web Development
ISBN: 1861002092
</shameless_author_plug>
----------------------------------------------

"Paul" <Pa**@nospam.com> wrote in message
news:03****************************@phx.gbl...
Thanks for all your advice. But I still can't solve it.
Here's the situation:
web.config impersonation is set to true (needed for other
parts in the project)
No anonymous access allowed in IIS.
On the folder containing the .mdb file I have full control.

When I set the impersonation to false, the database-
connection does work...

Anyone any advice? I don't have a clue anymore...

Thanks!
Paul
-----Original Message-----
I had the same very informative error when I tried to

migrate my app
from the test server to the app server. In my case, the

problem was
two things - one was I had set impersonation to true in

the web.config
and the IUSR account didn't have read/write on the folder

containing
my .mdb file.
HTH - I feel your pain. It took me a week to fix that

one.

"Paul" <pa**@nospam.com> wrote in message

news:<07****************************@phx.gbl>...
Hi John,
They assigned full control to me, no use.
I also tried adding the iusr_machinename/aspnet account
(both change rights). It did not work.

There is no anonymous connection allowed.

Do you have a clue? When I run the application on my w2k workstation, everybody can acces my app.

Thanx in advance,
Paul
>-----Original Message-----
>I guess the question is full control for whom - I would start by assigning
>it to everyone, and allow anonymous connection in IIS,
then work out where
>you lose permission to access the DB as you apply
restrictions.....
>
>--
>Regards
>
>John Timney (Microsoft ASP.NET MVP)
>----------------------------------------------
><shameless_author_plug>
>Professional .NET for Java Developers with C#
> ISBN:1-861007-91-4
>Professional Windows Forms
> ISBN: 1861005547
>Professional JSP 2nd Edition
> ISBN: 1861004958
>Professional JSP
> ISBN: 1861003625
>Beginning JSP Web Development
> ISBN: 1861002092
></shameless_author_plug>
>----------------------------------------------
>
>"Paul" <Pa**@nospam.com> wrote in message
>news:00****************************@phx.gbl...
>> Hi John,
>> Even when they assign 'full control' rights I still
>> receive this error.
>>
>> Does that make any sense to you?
>>
>> Thanks,
>> Paul
>> >-----Original Message-----
>> >Have you checked that the directory that holds the MDB file has write
>> >permission for people who are not domain admins? You might want to consider
>> >setting the app permissions to impersonate the logged on
user, and allow
>> >write for authenticated users.
>> >--
>> >Regards
>> >
>> >John Timney (Microsoft ASP.NET MVP)
>> >----------------------------------------------
>> ><shameless_author_plug>
>> >Professional .NET for Java Developers with C#
>> > ISBN:1-861007-91-4
>> >Professional Windows Forms
>> > ISBN: 1861005547
>> >Professional JSP 2nd Edition
>> > ISBN: 1861004958
>> >Professional JSP
>> > ISBN: 1861003625
>> >Beginning JSP Web Development
>> > ISBN: 1861002092
>> ></shameless_author_plug>
>> >----------------------------------------------
>> >
>> >"Paul" <Pa**@nospam.com> wrote in message
>> >news:0d****************************@phx.gbl...
>> >> Hi all,
>> >> On my local pc I have built a webpage which reads
data
>> >> from a ms-access file. No problem at all. When I
place
the
>> >> files on our intranet-server I receive an error:
>> >>
>> >> System.Data.OleDb.OleDbException: Unspecified error >> >>
>> >> When I am a member of the domainadmins it works just fine,
>> >> so it must be a rights issue. Can anyone tell me
what
>> >> kind of rights are needed to make this work for all users
>> >> in our company?
>> >>
>> >> Thanks,
>> >> Paul
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>
>.
>

.

Nov 17 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Bennett Haselton | last post by:
I want to get an ASP.Net hosting account with my ISP, and I'm trying to find out what level of access to the server is requried in order for me to view the server in Server Explorer in Visual...
29
by: DraguVaso | last post by:
Hi, I'm having this error in a VB.NET-application at the moment that I attempt to read data from an SQL Server: The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data...
5
by: Graham | last post by:
I have created a custom MembershipProvider called "LassieMembershipProvider" that derives from "MembershipProvider". This providor is located in a Businesslogic layer dll called...
3
by: Stan | last post by:
ASP.NET site runs under Windows Authentication, Anonymous Access is unchecked. Page tries to create NET component (regular assembly, not ES) and fails with 'Access Denied' We don't want to give...
2
by: vikas.bhatia | last post by:
Is this still true? http://groups.google.com/group/comp.databases.ibm-db2/browse_thread/thread/58c6c36ce9006d50/778f98749d8e2983?lnk=st&q=DB2+Connect+product+license&rnum=6#778f98749d8e2983 would...
2
by: rcp | last post by:
Hi all, I've read all posts from all existing threads and none of them worked to solve my problem, although its exactly the same. I'll try to explain my case and see if a kind soul could help me...
1
by: Thomas Strauss, SRS | last post by:
Hi, I have a really hard time to find the access rights required for monitoring a printing queue or share in windows XP or Win2000/2003 server. We have an application that will remote control...
3
by: Corey B | last post by:
I have a web server running IIS 6. The network security team here has completely locked down the server. They have installed an application called Cisco Security Agent (CSA). What CSA does is...
2
by: Rudolf Bargholz | last post by:
Windows 2003 R2 Server DB2 Express C Version 9 DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL09012" with level identifier "01030107". Informational tokens are "DB2...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.