[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

Security Problem in Access

I created a MS Access Contact database and also creater user groups for security.  I am the owner and administrator of the file, but when I try to edit anything, it's telling me:

"You don't have permission to read 'Contacts.'
To read this object, you must have Read Design permission for it."

How do I remove the security features so that it goes back to being a normal DB without any limitations?  I'm new to the security thing and screwed it up.  
0
mlswift27
Asked:
mlswift27
  • 5
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:

Here are some links ...

step by step instructions on how to do it right
www.jmwild.com   

Excellent resource book which I have
http://www.vb123.com/map/       

Microsoft info:
http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq.asp
http://support.microsoft.com/?id=207793

Access Security Manager:

http://support.microsoft.com/kb/236010/en-us.  

mx
0
 
mlswift27Author Commented:
Also, I looked at the User and Group Permissions and the current owner for the entire database is <Unknown>.  So how do I change that?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I can mainly suggest to look at the references above ...  it's hard for me to say ... since I did not create the MDW.

However ... seems you can use the workgroup administrator tool  ... and just point to System.MDW ?

mx
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
mlswift27Author Commented:
<seems you can use the workgroup administrator tool  ... and just point to System.MDW >
Can you explain how to do that?  I dont know what that is or where to find it...
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
sure:

Access Menu>>Tools>>Security>>Workgroup Administrator ...

Click Join ... navigate to a System.mdw file (assuming it has NOT been modified) ...  ... then OK on out .

mx

0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
btw ... this may or may not work ... depending on the actual state of your mdb ...

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now