Access Database Privileges

Discussion in 'General troubleshooting' started by zgdt, Oct 8, 2009.

  1. I receive the following error when trying to open my Access database:

    "The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file."

    Read, Write, Execute is implemented on the database.
     
  2. Ray

    Ray

    Try updating the trust level on the web.config file. To do this connect to our server using FTP. Navigate to the web.config file and you should have an option on your FTP client to edit the file. Typically the file will open in Microsoft notepad. Simply scroll down until you see a line that reads..

    <system.web>
    <trust level=....

    Next to it type the line "Full"...

    If you do not see these line in the web.config file then you will have to type in the line yourself. These elements which are standard elements do not necessarily have to be in the web.config file. If they are not, they will take the default value set on the server which is of course...

    <trust level="Medium"/>

    One thing you want to be aware of is that the web.config file is very sensitive. It is case sensitive so you will have to make sure you pay close attention on how you spell it.

    Another way of changing the trust level which is much easier is through the IIS 7 Manager. Download the IIS 7 Manager which is free from Microsoft and set it up to connect to our server. Once you are connected go the the button that is labeld .Net Turst Levels and you will find a drop down box where you can choose Full. This will set the trust level to full without you having to go in and changing any line coding.
    This is by far the easiest way to do it. Look at this kb article for instructions on how to setup IIS 7 Manager to connect to the server. It should also have a link where you can download IIS 7 Manager.

    For further reading any your own knowledge, you may also want to look at this link to help you understand more on the Trust element of .Net.

    http://msdn.microsoft.com/en-us/library/tkscy493.aspx
     
    Last edited by a moderator: Oct 14, 2015

Share This Page