I recently screwed up and removed the "Administer" permissions from my
"Admin" user group in a work application. Of course, didn't think ahead and
assign the "Administer" permissions to any other group or user. Now I can't
do anything in the application as it tells me "You need Administer
permissions to..."

Tried importing all tables/forms/quieries/etc. to another db, however, can't
do that because I can't assign all the permissions to the Users group,
because no Administer permissions.

Tried creating a new user group and assigning it the Administer, but same
error message.

Anyone know of a breakpoint or other way I can reassign the "Administer"
permissions to the Admin user group?

RAM wrote:
> I recently screwed up and removed the "Administer" permissions from my
> "Admin" user group in a work application. Of course, didn't think
> ahead and assign the "Administer" permissions to any other group or
> user. Now I can't do anything in the application as it tells me "You
> need Administer permissions to..."
>
> Tried importing all tables/forms/quieries/etc. to another db,
> however, can't do that because I can't assign all the permissions to
> the Users group, because no Administer permissions.
>
> Tried creating a new user group and assigning it the Administer, but
> same error message.
>
> Anyone know of a breakpoint or other way I can reassign the
> "Administer" permissions to the Admin user group?

Have you opened the file while logging in as the owner of the database object?
That account should be able to administer the app based on his ownership rather
than needing specific permissions.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

"RAM" <(E-Mail Removed)> wrote in message
news:48F94E47-94AE-4C97-ABB3-(E-Mail Removed)...
>I recently screwed up and removed the "Administer" permissions from my
> "Admin" user group in a work application. Of course, didn't think ahead
> and
> assign the "Administer" permissions to any other group or user. Now I
> can't
> do anything in the application as it tells me "You need Administer
> permissions to..."


It's not possible to remove all users from the Admins Group. At least one
user must be a member of this group.

--
Joan Wild
Microsoft Access MVP