Backend DB Password

  • Thread starter Thread starter Lez
  • Start date Start date
L

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
 
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
 
Lez said:
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
Click to expand...

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
 
Back
Top