IIS7: classic ASP application write access to .mdb file using windows authentication
I have a classic ASP application I want to run on my website (IIS7). This site contains an .mdb database file. I have enabled windows authentication and disable anonymous under authentication. I want members of a certain domain group (TESTGROUP) to have access to write to the database through the website, but I don't want them to have direct access to the files through windows. I cannot seem to find the correct permissions for the 开发者_JAVA技巧.mdb file to make this possible.
Simply, that's not directly possible with Ms Access. Why not using Sql Server Express, it's free, much more stable and you have full control of your access rights.
If you have to use MsAccess, why not add a Webservice before it, and use active directory for access control.
This is a good start: See if user is part of Active Directory group in C# + Asp.net
精彩评论