security on back end mdb

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The main mdb was split into an mde and a back end mdb. the back end mdb is on a server and contains
the data. the mde contains the queries, forms, reports, macros and modules and is on each work station.
the mde is password protected. all special keys, shift key and function keys have been disabled on the
mde to prevent getting at the programs.
all queries have read with owner permissions. how do i protect the back end mdb?

if someone, other than the users for the application, gets to the server, one can easily get to the
tables and extract the data.
 
You need to use user-level security (via the Wizard if you like) to secure
the back end *as well as* the front end database. Then open the front end
using the associated MDW (security workgroup) file.
 
You do understand that the users must have no permissions to the back-end
tables? Only the >owner of the RWOP queries< should have permission to the
back end tables. If any >normal user< is the owner of the RWOP queries,
then, you have not understood how to use RWOP queries.

HTH,
TC
 
Back
Top