Cannot edit Workgroup users

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I need to add a user to a security group, but it only open in read-only -
cannot add to user list or change an existing user record. I have joined the
workgroup with wrkgadm.exe and can see the user tables. The DB app is
"compiled" so I cannot convert it, canI?

I have tried this under Access 2000 & 2003.

"Record(s) cannot be read; no read permisssion on 'MSysObjects'"

"Record(s) cannot be read; no read permission on 'MSysACEs'"

and finally,

"You can't make changes to the database objects in the database 'Name'

Thanks for any help.
 
Your description makes it sound as though you are opening the mdw file
directly. You shouldn't/needn't do so.

Just start any session of Access using your secure mdw. Create a
desktop shortcut with the following in it:
"path to msaccess.exe" /wrkgrp "path to secure mdw"

To add a user, go to Tools, Security, Accounts, and create a new user
and modify their group membership. Close Access, and then reopen it via
the shortcut above (this time login using the username you just
created - their password will be blank/null). Now go to Tools,
Security, Accounts and click on change password, and change their
password from null to something else.

Joan Wild
MS Access MVP
 
Thanks Joan!

The first wrinkle I had to overcome was activating the Security option.
Through sheer force of will, I figured out I had to Reset the Security
Option. Voila, the rest of the tools menu showed up. Then followed your
steps

Thanks much!
 
Back
Top