Access 2007 Error 2614 - User level Security

23 Oct 2007 2:51 PM

Uncle Buck

I am a relatively experienced Access developer, but I am trying something I
have not tried for several versions.

I have a main form (frmMainMenu), with a listbox (lstMenu) presenting
available Forms on the left, and an empty subform control on the right
(sfrmMain).

By dbl-Clicking on a form in the listbox, my intent is to have the
appropriate form open in the subform control.
Me.Controls("sfrmMain").SourceObject = strChoice where strChoice is the name
of the form I want inserted.

Of course, with administrative privelages it works great, but once I start
to reduce user privelages, and testing under those accounts I get the
following message:

Run-time error '2614' You don't have permission to insert this form into
another form.

Any suggestions or resolutions?

Thanx in advance

23 Oct 2007 3:10 PM

Joan Wild

They'll need modify design permission on frmMainMenu.

--
Joan Wild
Microsoft Access MVP

Show quote

"Uncle Buck" <Uncle B***@discussions.microsoft.com> wrote in message news:41D2D8E6-5CBE-4DA6-A83F-F22FF0ABD699@microsoft.com...
>I am a relatively experienced Access developer, but I am trying something I
> have not tried for several versions.
>
> I have a main form (frmMainMenu), with a listbox (lstMenu) presenting
> available Forms on the left, and an empty subform control on the right
> (sfrmMain).
>
> By dbl-Clicking on a form in the listbox, my intent is to have the
> appropriate form open in the subform control.
> Me.Controls("sfrmMain").SourceObject = strChoice where strChoice is the name
> of the form I want inserted.
>
> Of course, with administrative privelages it works great, but once I start
> to reduce user privelages, and testing under those accounts I get the
> following message:
>
> Run-time error '2614' You don't have permission to insert this form into
> another form.
>
> Any suggestions or resolutions?
>
> Thanx in advance

23 Oct 2007 3:21 PM

Uncle Buck

Hi Joan, thanx for the post. As it turned out, it is read permission on the
form going into the subform control. Originally I had set the Modify
permission on the frmMainMenu & it did nothing, which confounded me &
prompted the post.

Thanx for your suggestion though.

Show quote

"Joan Wild" wrote:

> They'll need modify design permission on frmMainMenu.
>
> --
> Joan Wild
> Microsoft Access MVP
> "Uncle Buck" <Uncle B***@discussions.microsoft.com> wrote in message news:41D2D8E6-5CBE-4DA6-A83F-F22FF0ABD699@microsoft.com...
> >I am a relatively experienced Access developer, but I am trying something I
> > have not tried for several versions.
> >
> > I have a main form (frmMainMenu), with a listbox (lstMenu) presenting
> > available Forms on the left, and an empty subform control on the right
> > (sfrmMain).
> >
> > By dbl-Clicking on a form in the listbox, my intent is to have the
> > appropriate form open in the subform control.
> > Me.Controls("sfrmMain").SourceObject = strChoice where strChoice is the name
> > of the form I want inserted.
> >
> > Of course, with administrative privelages it works great, but once I start
> > to reduce user privelages, and testing under those accounts I get the
> > following message:
> >
> > Run-time error '2614' You don't have permission to insert this form into
> > another form.
> >
> > Any suggestions or resolutions?
> >
> > Thanx in advance
>

23 Oct 2007 3:14 PM

Uncle Buck

My apologies, I figured it out on my own like I usually do, which is why I
rarely post.

To make this work, the 'Read Design' flag must be set for the user on the
form being inserted, which I should have known. I thought it may have been
permissions on frmMainMenu. I also wondered if it was changes in 2007 that I
was not aware of.

Thanx, and hopefully if some else else runs into this issue, this post may
help.

Show quote

"Uncle Buck" wrote:

> I am a relatively experienced Access developer, but I am trying something I
> have not tried for several versions.
>
> I have a main form (frmMainMenu), with a listbox (lstMenu) presenting
> available Forms on the left, and an empty subform control on the right
> (sfrmMain).
>
> By dbl-Clicking on a form in the listbox, my intent is to have the
> appropriate form open in the subform control.
> Me.Controls("sfrmMain").SourceObject = strChoice where strChoice is the name
> of the form I want inserted.
>
> Of course, with administrative privelages it works great, but once I start
> to reduce user privelages, and testing under those accounts I get the
> following message:
>
> Run-time error '2614' You don't have permission to insert this form into
> another form.
>
> Any suggestions or resolutions?
>
> Thanx in advance