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.
--
Jim McDermott

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 wrote:
> 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.

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!
--
Jim McDermott


"Joan Wild" wrote:

> 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 wrote:
> > 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.
>