Can't Edit Forms

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?

Answer 1

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.....

Answer 2

User565442435 posted

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

Answer 3

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 ?

Answer 4

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.

Answer 5

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

Answer 6

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

Answer 7

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 

Answer 8

User565442435 posted

Sorry, thought this was an access forum. 

Answer 9

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)