#31
  1. Moderator From Beyond
    ASP Mastermind (5000+ posts)

    Join Date
    Sep 2004
    Location
    Israel
    Posts
    31,135
    Rep Power
    2926
    Originally Posted by fassi_79
    I have one question. i have developed a IIS / ASP/ Windows 2003 server based a small application in my office. Now i have given them Read / Write access on folder. but problem is this they can access these files easily and delete them too. how can i handle this situation to restrict them to delete file even i dont want to let them open the source files.
    If you're using Integrated Windows Authentication you're pretty much stuck.

    If you're using Anonymous Access give the Read/Write permissions only to the IUSR account and only Read to Everyone and Authenticated Users and since the website is running under IUSR it should be able to read/update the database while the users can't.
  2. #32
  3. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Mar 2011
    Posts
    11
    Rep Power
    0

    Post problem


    hi! When i right click on the file there's a pop up window but there's only two tab that appears, the general and summary tab, there's no security tab.What will I do?
  4. #33
  5. Moderator From Beyond
    ASP Mastermind (5000+ posts)

    Join Date
    Sep 2004
    Location
    Israel
    Posts
    31,135
    Rep Power
    2926
    Originally Posted by pirate
    hi! When i right click on the file there's a pop up window but there's only two tab that appears, the general and summary tab, there's no security tab.What will I do?
    What OS? If Windows XP, read step #2 under "Window XP/Windows 2003 Server" section in the original post - by default the Security tab is indeed hidden.
  6. #34
  7. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Mar 2011
    Posts
    11
    Rep Power
    0

    Post


    Originally Posted by Shadow Wizard
    What OS? If Windows XP, read step #2 under "Window XP/Windows 2003 Server" section in the original post - by default the Security tab is indeed hidden.
    Thank you for! It works by the way can you answer my anothe post regarding the asp problem?...Please
  8. #35
  9. Moderator From Beyond
    ASP Mastermind (5000+ posts)

    Join Date
    Sep 2004
    Location
    Israel
    Posts
    31,135
    Rep Power
    2926
    Originally Posted by pirate
    Thank you for! It works by the way can you answer my anothe post regarding the asp problem?...Please
    Once you set permissions to IUSR account the error should be solved.. unless you still get "file not found" even though you gave permissions?
  10. #36
  11. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Mar 2011
    Posts
    11
    Rep Power
    0

    Smile


    Originally Posted by Shadow Wizard
    Once you set permissions to IUSR account the error should be solved.. unless you still get "file not found" even though you gave permissions?
    I did it ! Thank you so much!...Can you help me again in my post regarding the log in page..Please.......it's on the first page of the forum.....
    Thank you...
  12. #37
  13. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Jul 2011
    Posts
    1
    Rep Power
    0
    I am very helpful this great information i really like it. Thanks for share.
  14. #38
  15. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Nov 2011
    Posts
    2
    Rep Power
    0

    update to Windows 7 please


    Would you mind terribly updating your instructions to Windows 7 please (local machine)? I am converting a classic asp program I wrote before NET that writes to an Access db with a unique name to the logged in user. Therefore the connection string is created in the code behind. I have run into the wall of being unable to do this in NET because of Windows write permissions both in my dev environment on my laptop as well as web host (GoDaddy). I have read the MSDN page on the subject but like yours it's for Windows 2000 and XP and says to add <machine name>\ASPNET as the user. That selection is rejected. I am completely stuck. Thank you.
  16. #39
  17. Moderator From Beyond
    ASP Mastermind (5000+ posts)

    Join Date
    Sep 2004
    Location
    Israel
    Posts
    31,135
    Rep Power
    2926
    Originally Posted by janwayne
    Would you mind terribly updating your instructions to Windows 7 please (local machine)? I am converting a classic asp program I wrote before NET that writes to an Access db with a unique name to the logged in user. Therefore the connection string is created in the code behind. I have run into the wall of being unable to do this in NET because of Windows write permissions both in my dev environment on my laptop as well as web host (GoDaddy). I have read the MSDN page on the subject but like yours it's for Windows 2000 and XP and says to add <machine name>\ASPNET as the user. That selection is rejected. I am completely stuck. Thank you.
    If you reached the stage of "adding <machine name>\ASPNET as the user" then you're in the right direction - I might add the technical details how to reach it, but it won't help you any further.

    What you mean by "That selection is rejected"? What exact error did Windows throw?
  18. #40
  19. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Nov 2011
    Posts
    2
    Rep Power
    0
    Originally Posted by Shadow Wizard
    If you reached the stage of "adding <machine name>\ASPNET as the user" then you're in the right direction - I might add the technical details how to reach it, but it won't help you any further.

    What you mean by "That selection is rejected"? What exact error did Windows throw?
    It said "there is no such object". Of course I double checked the machine name.

    To explain more about my environment and what I'm doing, I use Visual Studio 2010 with SQL Server 2008R2 on my laptop with Windows 7 OS. When I'm ready I ftp ("Copy Website) files (I don't "publish") onto the web server at GoDaddy.

    Without going into too much detail, my users can build an equine competion event in the SQL database on the web. In a regular folder (not the App_Data folder) with write permission resides a Access database named "EventDB.mdb" meaning it has all the tables but they're empty. Immediately before the event the event owner can click a button which (1) file.copy the EventDB.mdb to a file uniquely named for that event (using the primary key of the EventID); e.g. Eventdb388.mdb. (2) Therefore the connection string is created at that time in the code. (3) All the SQL tables are read for that event's data then written to the Access db. As stated previously this works fine in class asp.

    However, what happens in NET when I step thru my laptop environment in debug is that the connection string is correct until the cmd.ExecuteNonquery. Then it errors saying it cannot fine the path. The path it displays is not the path it just shown in the connection string object.

    Correct path: Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\AACL_IT\Documents\Visual Studio 2008\WebSites\NATRC5net\rmsnet\eventdb\2000eventdb 388.mdb

    Is changed to: 'Could not find file 'C:\Program Files\Common Files\Microsoft Shared\DevServer\10.0\NATRC5.mdb'

    The point is it does this both on my laptop environment as well as the web. Further research led me to msdn which says that I can read from Access but not write to it without setting a Windows permission such as you are talking about but that instruction is several years old and Windows 7 is different.

    Thank you.
  20. #41
  21. Moderator From Beyond
    ASP Mastermind (5000+ posts)

    Join Date
    Sep 2004
    Location
    Israel
    Posts
    31,135
    Rep Power
    2926
    Originally Posted by janwayne
    It said "there is no such object". Of course I double checked the machine name.

    To explain more about my environment and what I'm doing, I use Visual Studio 2010 with SQL Server 2008R2 on my laptop with Windows 7 OS. When I'm ready I ftp ("Copy Website) files (I don't "publish") onto the web server at GoDaddy.

    Without going into too much detail, my users can build an equine competion event in the SQL database on the web. In a regular folder (not the App_Data folder) with write permission resides a Access database named "EventDB.mdb" meaning it has all the tables but they're empty. Immediately before the event the event owner can click a button which (1) file.copy the EventDB.mdb to a file uniquely named for that event (using the primary key of the EventID); e.g. Eventdb388.mdb. (2) Therefore the connection string is created at that time in the code. (3) All the SQL tables are read for that event's data then written to the Access db. As stated previously this works fine in class asp.

    However, what happens in NET when I step thru my laptop environment in debug is that the connection string is correct until the cmd.ExecuteNonquery. Then it errors saying it cannot fine the path. The path it displays is not the path it just shown in the connection string object.

    Correct path: Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\AACL_IT\Documents\Visual Studio 2008\WebSites\NATRC5net\rmsnet\eventdb\2000eventdb 388.mdb

    Is changed to: 'Could not find file 'C:\Program Files\Common Files\Microsoft Shared\DevServer\10.0\NATRC5.mdb'

    The point is it does this both on my laptop environment as well as the web. Further research led me to msdn which says that I can read from Access but not write to it without setting a Windows permission such as you are talking about but that instruction is several years old and Windows 7 is different.

    Thank you.
    To be honest, I have never really used Access on Windows 7 environment and was hoping to have time to try it this weekend.. but didn't have - sorry.

    Generally speaking, the logic you're using is.. weird. Why not have one single database with users table and permissions table etc.. ?

    Until I see this issue for myself I can't really tell about this permission issue of Access with Windows 7 but do have some questions:

    1. If you change the connection string to use "ordinary" MDB file does it work?
    2. Have you asked your host about this?
  22. #42
  23. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Nov 2011
    Location
    USA
    Posts
    1
    Rep Power
    0
    Hi there Shadow wizard, I have been having the same issues too. But what you said here isn't working anymore. Care to suggest any other solution?
    Last edited by Shadow Wizard; December 1st, 2011 at 03:03 AM. Reason: removed spam signature
  24. #43
  25. Moderator From Beyond
    ASP Mastermind (5000+ posts)

    Join Date
    Sep 2004
    Location
    Israel
    Posts
    31,135
    Rep Power
    2926
    Originally Posted by glenda66
    Hi there Shadow wizard, I have been having the same issues too. But what you said here isn't working anymore. Care to suggest any other solution?
    "Not working anymore" is not helpful. Please say exactly what you tried and what happened and maybe I can help.

    Also, don't add your website as signature to your posts, it makes them smell of spam. Having it in your profile is fine, when you'll become trusted member (30 days and 30 posts if I recall correctly) you'll be allowed to have "real" signature.
  26. #44
  27. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Nov 2011
    Location
    New York
    Posts
    1
    Rep Power
    0

    Remote Technical Support


    yes may be you are right its XP professional
  28. #45
  29. Moderator From Beyond
    ASP Mastermind (5000+ posts)

    Join Date
    Sep 2004
    Location
    Israel
    Posts
    31,135
    Rep Power
    2926
    Originally Posted by charlottelyn
    yes may be you are right its XP professional
    What are you talking about??

Similar Threads

  1. Newbie question on access database.
    By XandarX in forum Visual Basic Programming
    Replies: 6
    Last Post: June 6th, 2005, 05:59 PM
  2. Same DB plays different with XP and W2K
    By datasurf in forum Microsoft Access Help
    Replies: 3
    Last Post: June 2nd, 2005, 11:41 PM
  3. How to access Remote Access Database using ASP.net
    By arvind2004 in forum .NET Development
    Replies: 1
    Last Post: October 3rd, 2004, 09:24 AM
  4. Access Database HELP...URGENT
    By bzibee in forum Microsoft Access Help
    Replies: 1
    Last Post: June 3rd, 2004, 11:25 AM
  5. problems with access database using DSN
    By saunaG in forum ASP Development
    Replies: 1
    Last Post: February 13th, 2004, 03:15 PM

IMN logo majestic logo threadwatch logo seochat tools logo