Re: how can i secure a choice on a switchboard in access?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for you quick response Rick. Could you give me more detail on how to
protect the form?

"Rick B" wrote:

> You can't do it on the switchboard, just do it on the form or report that
> the switchboard calls.
>
> Personally, I don't secure individual objects with passwords. It is not
> very secure, and I don't want password prompts popping up everytime an
> important feature is used. This means your most important users are the
> most inconvenienced.
>
> A better option is to implement user-level security. Have each user sing on
> one time when they open the file and then their access is set for every
> object and function in the file. They will only be able to do what you have
> given them permission to do.
>
>
> --
> Rick B
>
>
>
> "Misterted" <Misterted@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:3FD9F5E1-DAF2-478D-A318-7300AA2BF9FB@xxxxxxxxxxxxxxxx
> > Hi,
> > I have an access database setup which I have the need to secure one of the
> > choices from the swithboard. I would like to use a password so that only
> > certain people can update this choice.
> >
> > Your help would be appreaciated.
> >
> >
> > Thanks,
> > Ted
>
>
>
.

Relevant Pages

  • Re: more than one db -one without security one with security
    ... You do not need to join your secure.mdw if the shortcut includes it. ... Rick B ... > Then setup secure icon pointing to the secure mdw and use it instead of ... Next time they open a database it will use whatever ...
    (microsoft.public.access.security)
  • Re: Workgroup file for one db only (not to apply to other dbs)
    ... make a custom file extension ... shortcut to open the secure mdb ... I can use a shortcut ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: Sample HR database
    ... "Rick B" wrote: ... Access is not a secure environment. ... I'd not store such sensative data in Access. ... I have found many designs but im looking for something to ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Trying to create a password
    ... Rick B ... they could create their own report ... The proper way to secure your database is to implement ... User-level security is very detailed to implement. ...
    (microsoft.public.access.security)
  • Re: how can i secure a choice on a switchboard in access?
    ... the switchboard calls. ... I don't secure individual objects with passwords. ... > I have an access database setup which I have the need to secure one of the ...
    (microsoft.public.access.security)