vb.net and access

I have set up an access database and am trying to pull data from it. Everything was going fine until I closed out the program and tried to reopen it. I got the following error:

Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

What have I done wrong. There shouldn't be any type of security on this drive.

Larry




Answer this question

vb.net and access

  • harrier_coder

    Just to test I created a scaled down version of the program using an access db on my hard drive and everything worked fine. How is the network causing this problem

  • biw

    I have a sneaky feeling that you have the db open in Access or Access was not properly shut down and the lock file is keeping the db from being initialized.....Make sure the db is not opened exclusively by you or another user. If the db is closed make sure the idb (locking file) has been closed and deleted

    I have seen this issue several times before in the dev environment only



  • Adam Miles

    If it was all working ok, prior to closing your app, it may be possible that you didn't close the connection. I used to have a similar problem if I stopped a program with the debugger etc.

    Have you tried opening the db with access when youhave this condition


  • DennisMW

    Yes it is on a network drive.   I opened it this morning and got a trust level message.  How and where do I set it to full.

     



  • Mithat Mese

    I am using access as the db. It happened when I saved the program. Very confused here.



  • QCH


    You have to set trust levels. This is part of the security implementation for running .NET apps across the network. See the following:

    How to deploy a .NET Framework application to run from a network location



  • Rozee


    Are you working with the project on a network drive

  • vb.net and access