NJudson
Who farted?
- Local time
- Yesterday, 22:15
- Joined
- Feb 14, 2002
- Messages
- 297
Hello all, its been a very long time since I've been here. I'm having to brush off the dust and get back to using Access a bit here and I'm tasked with trying to set permissions on a database which our department uses. The actual database I will eventually set permissions on is an Access 2000 DB.
I've tried setting up security years ago and had all sorts of problems and then abandoned the project. So now I am re-trying and I used a test db to do this so I didn't screw things up. The test db is Access2003. I've read tuturials on how to use the Wizard, but I continue to "lock myself" out of the db.
Here's a step by step process of what I've done.
1) Create a new workgroup information.
2) Name my WID (left it as the random alphanumeric code) and selected the "I want to create a shortcut to open my security-enhanced database."
3) Have all database objects selected for security.
4) Selected "Full Permissions" and "Read-Only Permissions" groups for the workgroup information file.
5) Entered Users.
6) Set User permissions.
7) Saved the copy of the unsecured database.
When its all done then when I try to open the database and I receive the following popup.
"You do not have the necessary permissions to use the <database> object. Have your system administrator or the person who created this object establish the appropriate permissions for you."
What steps or concepts am I missing here? What I don't understand is shouldn't there be a login popup that comes up when opening the database? This is one area of access I understand very little about. Do the mdw files need to be in a specific location? I appreciate anyone's help on this. Thanks.
I've tried setting up security years ago and had all sorts of problems and then abandoned the project. So now I am re-trying and I used a test db to do this so I didn't screw things up. The test db is Access2003. I've read tuturials on how to use the Wizard, but I continue to "lock myself" out of the db.
Here's a step by step process of what I've done.
1) Create a new workgroup information.
2) Name my WID (left it as the random alphanumeric code) and selected the "I want to create a shortcut to open my security-enhanced database."
3) Have all database objects selected for security.
4) Selected "Full Permissions" and "Read-Only Permissions" groups for the workgroup information file.
5) Entered Users.
6) Set User permissions.
7) Saved the copy of the unsecured database.
When its all done then when I try to open the database and I receive the following popup.
"You do not have the necessary permissions to use the <database> object. Have your system administrator or the person who created this object establish the appropriate permissions for you."
What steps or concepts am I missing here? What I don't understand is shouldn't there be a login popup that comes up when opening the database? This is one area of access I understand very little about. Do the mdw files need to be in a specific location? I appreciate anyone's help on this. Thanks.