Security Wizard

[handleodhran]

I've spent a few days putting together a database. Thought it would be a
good idea to protect it so I used the Security Wizard. Now when I try and
open the database I get the message "You do not have the necessary
permissions to use the "C:\Doc..........mdb" object. Have you system
administrator or the person who created this object establish the
appropriate permissions for you" I'm not sure what to do at this stage and
how to fix this up. I've printed out a copy of the "One step security wizard
report" The information which is probably most useful is the following;

Groups
Name: Admins
Group ID: <Previously Created>
Users: Odhran OBrien

Name: Users
Group ID: <Previously Created>
Users: Odhran OBrien

Users

Name: Odhran OBrien
Personal ID: 0ppHLE8xdAgnA8flVgSF
Password:
Groups:
Admins

Name: admin
Personal ID: <Previously Created>
Password: Hs8vTAKXIgQbE
Groups:
Users

Any ideas how I get this back up and running?

 

[ZmrAbdulla]

There is a 12 page tutorial about the security wizard & permissions. It may help you.

http://www.microsoft-accesssolutions.co.uk/access_security.htm

regards

Zameer Abdulla

http://www.geocities.com/zameerabd/

 

[corded]

I've looked over the referenced URL and it is thorough in describing how to do this. However, what if the database was already created with security and now some of the tables are unaccessible due to "could not read definitions;no read definitions permission for table or query <name>, (error 3110)" appears?

I've experienced this error and have not been able to access the tables, even after creating another workgroup in Access' database security.

Any suggestions for this problem?