Backend DB Password

2 Jul 2006 7:53 PM

Lez

Hi Guys,

Have spilt my database FE & BE.

The FE has a username & password function for them to sign in, However, I
need a way to password protect the BE database so as only authorised users
can access this.

Can anyone tell me how this is done please?

Many thanks

Lez

2 Jul 2006 10:29 PM

tina

you can add a password to the BE database by opening it to the database
window, and clicking Tools | Security | Set Database Password on the menu
bar. note that you'll need to re-link the BE tables to the FE database
*after* setting the BE password, otherwise the FE users will be prompted for
the BE password (or the links just won't work).

hth

Show quoteHide quote

"Lez" <lj_girvan_N-O_5***@hotmail.com> wrote in message
news:e9yx8EhnGHA.3440@TK2MSFTNGP04.phx.gbl...
> Hi Guys,
>
> Have spilt my database FE & BE.
>
> The FE has a username & password function for them to sign in, However, I
> need a way to password protect the BE database so as only authorised users
> can access this.
>
> Can anyone tell me how this is done please?
>
> Many thanks
>
> Lez
>
>

3 Jul 2006 9:33 AM

Keith Wilby

Show quote Hide quote

"Lez" <lj_girvan_N-O_5***@hotmail.com> wrote in message
news:e9yx8EhnGHA.3440@TK2MSFTNGP04.phx.gbl...
> Hi Guys,
>
> Have spilt my database FE & BE.
>
> The FE has a username & password function for them to sign in, However, I
> need a way to password protect the BE database so as only authorised users
> can access this.
>
> Can anyone tell me how this is done please?
>
> Many thanks
>
> Lez
>

Whilst joined to your custom workgroup, create a new blank db file then
import all of the tables from your BE. This is now your new BE to which you
can assign permissions. You'll have to either re-link to this new BE from
your FE else overwrite your old BE with the new one (giving it the same
name).

HTH - Keith.
www.keithwilby.com