Backend DB Password

[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

 

[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

 

[Keith Wilby]

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