C
Chris O''''Neill
I have just started the process of securing an Access XP application I have
developed, and I have run into a problem. Here's the steps I've done so far:
1. Created a new workgroup file and saved in the same directory as my MDB
file.
2. Using the new workgroup file, I opened my MDB file using the default
Admin user.
3. I created a user account for myself, and assigned myself to the Admins
and Users groups. I also removed the Admin user from the Admins group. So,
now, I'm the only member of the Admins group.
4. I ran the Access XP User-level Security Wizard to back-up my MDB file
and create a new, secured MDB file. During that process, I did not create
any users (I'll do that programatically when new users first log onto the
system) or user groups (I want to do that manually).
The Wizard seemed to run fine.... no error messages or any other
indications of problems. I then shutdown Access, restarted it, and was able
to log-on using my new user account and password.
I then went to the User and Group Accounts section and created the groups I
want. Again, no apparent problems doing this.
Finally, I went into the User and Group Permissions section to start
assigning permissions to my groups. I immediately found one table where the
following error message popped up:
"You can't view this object's permissions. To view or change permissions
for this object, you must have Administrator permission for it."
I don't seem to have this problem with any other object in the database, at
least so far. I have confirmed that I am a member of the Admins group and
have full "Administer" rights to the database, including that table.
What's happening, and how do I correct it???
Any and all help will be greatly appreciated!
Regards, Chris
developed, and I have run into a problem. Here's the steps I've done so far:
1. Created a new workgroup file and saved in the same directory as my MDB
file.
2. Using the new workgroup file, I opened my MDB file using the default
Admin user.
3. I created a user account for myself, and assigned myself to the Admins
and Users groups. I also removed the Admin user from the Admins group. So,
now, I'm the only member of the Admins group.
4. I ran the Access XP User-level Security Wizard to back-up my MDB file
and create a new, secured MDB file. During that process, I did not create
any users (I'll do that programatically when new users first log onto the
system) or user groups (I want to do that manually).
The Wizard seemed to run fine.... no error messages or any other
indications of problems. I then shutdown Access, restarted it, and was able
to log-on using my new user account and password.
I then went to the User and Group Accounts section and created the groups I
want. Again, no apparent problems doing this.
Finally, I went into the User and Group Permissions section to start
assigning permissions to my groups. I immediately found one table where the
following error message popped up:
"You can't view this object's permissions. To view or change permissions
for this object, you must have Administrator permission for it."
I don't seem to have this problem with any other object in the database, at
least so far. I have confirmed that I am a member of the Admins group and
have full "Administer" rights to the database, including that table.
What's happening, and how do I correct it???
Any and all help will be greatly appreciated!
Regards, Chris