RE: Securing the Front End database

AccessHelp,

1. Whenever I need to make changes to the FE, do I make changes on the actual >FE

YES, but you need to use the shortcut and log in as Admin.

2. If I do make changes to the actual FE, will the shortcut be reflected?

YES, the shortcut loads the changed FE file.

3. After I make changes, do I email the shortcut or actual FE to the users?

NEITHER. Once the FE is updated the changes will be seen by all users
provided the FE is on a shared network drive.

4. Where do I save the mdw file? Is it in the network where I have the BE?

YES

5. In the future, if I want to add a new user, how do I go about adding?

Tools, Security, User and Group Accounts, Users

NOTE:
If your FE is setup correctly then no one should be able to open that file
by double-clicking on it. If you double-click your FE and it opens without
any warning messages then something is very wrong, it is not secured.

For help on securing your FE look here: http://www.jmwild.com/security02.htm

-Alias




"AccessHelp" wrote:

Hello all,

First of all, I am still new to securing the database. What I want to do is
I want to secure my front end database from unauthorized people getting into
the database. Yesterday I was playing around with the User-Level Security
Wizard. As the results, I got a mdw, bak and shortcut of my Front End file.
Before I ask a few questions on what I confuse, I would like share with you a
little bit of what I do.

I make changes from time to time to the front end database. Then I email it
to the users. The BE is saved in the network. These are my questions:

1. Whenever I need to make changes to the FE, do I make changes on the
actual FE (or shortcut)?
2. If I do make changes to the actual FE, will the shortcut be reflected?
3. After I make changes, do I email the shortcut or actual FE to the users?
4. Where do I save the mdw file? Is it in the network where I have the BE?
5. In the future, if I want to add a new user, how do I go about adding?

Thanks.
.

Relevant Pages

  • Re: Security Wizard Locked ALL Dbs
    ... Username/Password for any access database I try to open ... I just want all of this security off ... Make a shortcut to your mdb file: ... Place the cursor at the far left of the Target ...
    (microsoft.public.access.security)
  • Re: secured database with Access 2002 or greater on network
    ... Not sure what the /wrkgrp goes with the database or the security ... Path of database located on F: ... you'll need to modify the shortcut so that the path to Access reflects ... in the same folder as the mdb. ...
    (microsoft.public.access.security)
  • Re: Multi user enviroment - part II
    ... Let's say for the sake of discussion that I have a multi-user database ... Give the new security file an ID, note the User, Organization, and ID ... MyAppFolder with the workgroup information file used when establishing ... "You can create a shortcut and enter this syntax as the target of the ...
    (comp.databases.ms-access)
  • Re: How to add 3 levels of access to a database
    ... You must follow the steps in Section 1 of the security FAQ exactly. ... you won't have a secured database. ... secure your database ... ... your shortcut - what's the value in the shortcut's Target setting? ...
    (microsoft.public.access.security)
  • Re: i give up...please tell me how to remove security
    ... Access Security: www.ltcomputerdesigns.com/Security.htm ... > When I copied the database over I also copied the "secured.mdw" file and ... > shortcut that I used to open it. ... I changed the workgroup in the target of the shortcut to refer to this ...
    (microsoft.public.access.security)
Loading