Link to home
Start Free TrialLog in
Avatar of spmcmorrow
spmcmorrow

asked on

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

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.
Avatar of Emad Gawai
Emad Gawai
Flag of United Arab Emirates image
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
Avatar of maXXXeE
maXXXeE
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.
Avatar of spmcmorrow
spmcmorrow

ASKER





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

Avatar of spmcmorrow
spmcmorrow

ASKER

maXXXeE  - there is no security tab when I right click on the file.  
ASKER CERTIFIED SOLUTION
Avatar of apresto
apresto
Flag of Italy image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of apresto
apresto
Flag of Italy image
Now when you right click on the database

Tick everything for:

'IUSR' and 'everyone' users
Avatar of spmcmorrow
spmcmorrow

ASKER

Thank you, I couldn't find that for the life of me.
Avatar of apresto
apresto
Flag of Italy image
Glad to help, thanks for the grade :o)