Cannot edit Workgroup users

[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.

 

[Joan Wild]

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

 

[Jim]

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!