How do you password protect a form

21 Sep 2006 5:11 AM

KAREN27

Hi all,

I have created an Access 2003 database that when opened it shows only the
mainform that has command buttons that access various other subforms.

One of these subforms is an input form from where you can enter data
that will go into a specified table.

I would like to secure this one and only subform so that unauthorised people
can not enter data or edit the data.

Thanks very much for your help

Regards Karen

21 Sep 2006 3:32 PM

Keith

I am in a similar situation. I think the answer is that you can't just
password protect a particular form. This would still leave the data table
un-protected. I think the solution is to set up permission for certain user
groups that folks login under.

Show quoteHide quote

"KAREN27" wrote:

> Hi all,
>
> I have created an Access 2003 database that when opened it shows only the
> mainform that has command buttons that access various other subforms.
>
> One of these subforms is an input form from where you can enter data
> that will go into a specified table.
>
> I would like to secure this one and only subform so that unauthorised people
> can not enter data or edit the data.
>
> Thanks very much for your help
>
> Regards Karen
>
>
>
>

21 Sep 2006 7:58 PM

Ray Cacciatore

The RIGHT solution is to implement user-level security and assign permissions
to the forms you want, and to the group of people you want.

You cannot password protect a form in Access.
There are less-secure ways of doing this though, which involve work.

Ray

Show quoteHide quote

"KAREN27" wrote:

> Hi all,
>
> I have created an Access 2003 database that when opened it shows only the
> mainform that has command buttons that access various other subforms.
>
> One of these subforms is an input form from where you can enter data
> that will go into a specified table.
>
> I would like to secure this one and only subform so that unauthorised people
> can not enter data or edit the data.
>
> Thanks very much for your help
>
> Regards Karen
>
>
>
>

22 Sep 2006 2:51 PM

abelinthecommunity

Hello Karen

I regularly password protect forms by using the command button to launch a
modal popup form that has only a text box on it. Entry of the correct
password into the text box launches the required form. As all my front ends
have the menu bar and other means of launching forms hidden then this command
button is the only way into that form.

Hope this is useful

Abel

Show quoteHide quote

"KAREN27" wrote:

> Hi all,
>
> I have created an Access 2003 database that when opened it shows only the
> mainform that has command buttons that access various other subforms.
>
> One of these subforms is an input form from where you can enter data
> that will go into a specified table.
>
> I would like to secure this one and only subform so that unauthorised people
> can not enter data or edit the data.
>
> Thanks very much for your help
>
> Regards Karen
>
>
>
>