How do I check or change permissions for the IUSR account on XP

Posted on 2005-03-30
Medium Priority
Last Modified: 2012-08-13
I am trying to solve the problem I have connecting to an access db using ASP .NET and an oledb connection and data adapter.
I get the following error.  

Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

Microsoft says to check the permissions that the IUSR<machine name> account has on the database file.  I don't see where to do this.  I am using IIS 5.0 and Visual Studio .Net 2003.  

Please help.  I need to get this resolved right away.
Question by:spmcmorrow
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 20

Expert Comment

ID: 13663617
verify that
1. the access db is not opened by u or any other user while trying your asp code.
2. the ms access file attribute is set READ ONLY.  

wait for furthere assistance

Expert Comment

ID: 13663721
right click on file (access file) and select properties.
choose the security tab. u can see the users that hav permission to use the file.

Author Comment

ID: 13663809

I have verified both of those things.  I cut and paste the values associated with the  OleDbConnection object below, if that is of any help.

conn      {System.Data.OleDb.OleDbConnection}      System.Data.OleDb.OleDbConnection

ConnectionString      "Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=4;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Data Source=C:\Inetpub\wwwroot\FLNutrition3\FLNutrition.mdb"      String

Provider      "Microsoft.Jet.OLEDB.4.0"      String

DataSource      "C:\Inetpub\wwwroot\FLNutrition3\FLNutrition.mdb"      String

State      Closed      System.Data.ConnectionState

ServerVersion      <error: an exception of type: {System.InvalidOperationException} occurred>      String

WordPress Tutorial 2: Terminology

An important part of learning any new piece of software is understanding the terminology it uses. Thankfully WordPress uses fairly simple names for everything that make it easy to start using the software.


Author Comment

ID: 13663822
maXXXeE  - there is no security tab when I right click on the file.  
LVL 23

Accepted Solution

apresto earned 2000 total points
ID: 13665098
Open a folder
Folder Options
Click the 'View' Tab
and UNtick the very last option (Use Simple File sharing(recommended))

Now you can see the Security Tab

LVL 23

Expert Comment

ID: 13665118
Now when you right click on the database

Tick everything for:

'IUSR' and 'everyone' users

Author Comment

ID: 13666636
Thank you, I couldn't find that for the life of me.
LVL 23

Expert Comment

ID: 13670315
Glad to help, thanks for the grade :o)

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question