Required rights to connect to access db

  • Thread starter Thread starter Paul
  • Start date Start date
P

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
 
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>
 
Hi John,
Even when they assign 'full control' rights I still
receive this error.

Does that make any sense to you?

Thanks,
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
 
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>
----------------------------------------------
 
Back
Top