Required rights to connect to access db

[Paul]

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

 

[John Timney \(Microsoft MVP\)]

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]

Hi John,
Even when they assign 'full control' rights I still
receive this error.

Does that make any sense to you?

Thanks,
Paul

 

[jayuya]

Does the aspnet account has rights to that directory?

jayuya

 

[Paul]

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

 

[John Timney \(Microsoft MVP\)]

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>
----------------------------------------------