locked
Can't Edit Forms RRS feed

  • Question

  • User565442435 posted

    We have a setup as follows. This database was built in access 2003 on xp and I am using 2007 on vista. It has a front end database with forms and queries and reports that links to a backend database with all of the data. There are multiple of these "front end" dbs that users use which all go back to the same back end. I am trying to change a form to add some new features. However, when I open the DB it says I don't have exclusive access and won't let me save. If I go back into access and try to open it exclusively, I get this error. 

    You do not have the necessary permissions to use the 'C:\DatabasePath\db.mdb' object. Have your system administrator or the person who created this object establish the appropriate permissions for you. 

    Any ideas on how I can gain exclusive access to this?

    Wednesday, August 11, 2010 10:18 AM

Answers

  • User-1199946673 posted

    These forums are intended for ASP.NET related questions only. This question really has nothing to do with ASP.NET or web development. So please, ask this question on a different (Access) forum:

    For example:

    http://www.tek-tips.com/threadminder.cfm?pid=181 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 11, 2010 11:53 AM

All replies

  • User1268001420 posted

    go to that folder where that mdb file is and right click on the file and go to properties

    see if u have all rights on the file or else give those rights

    like read write and so on.....

    Wednesday, August 11, 2010 10:36 AM
  • User565442435 posted

    I did have permissions but I went ahead and granted full access for everyone. I still get the error. 

    Wednesday, August 11, 2010 10:50 AM
  • User1268001420 posted

    are you able to open the file from outside the project like if u can double click the mdb file are you able to open it ?

    Wednesday, August 11, 2010 11:24 AM
  • User565442435 posted

    I can open the file just fine. I can run sql queries and everything. I just can't open it exclusively and I need to so I can edit the forms.

    Wednesday, August 11, 2010 11:38 AM
  • User1268001420 posted

    i found some artice with same issue please read it may be it helps you

    http://www.dbforums.com/microsoft-access/1617632-you-do-not-have-necessary-permissions-use-objectname-object.html



    Wednesday, August 11, 2010 11:44 AM
  • User1268001420 posted

    check this one too at the end there is open discussion please check that section


     

    http://www.experts-exchange.com/Databases/MS_Access/Q_21459235.html


    Wednesday, August 11, 2010 11:50 AM
  • User-1199946673 posted

    These forums are intended for ASP.NET related questions only. This question really has nothing to do with ASP.NET or web development. So please, ask this question on a different (Access) forum:

    For example:

    http://www.tek-tips.com/threadminder.cfm?pid=181 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 11, 2010 11:53 AM
  • User565442435 posted

    Sorry, thought this was an access forum. 

    Wednesday, August 11, 2010 12:07 PM
  • User-1199946673 posted

    Sorry, thought this was an access forum. 

     

    It is, but in the description you can read:

    " Discuss using Access as a data store for ASP.NET, and the AccessDataSource control."

    Like all forums on this website (http://www.asp.net)

     

     

    Wednesday, August 11, 2010 12:10 PM