Re: How to Give Admin and user access to a data file

Hi Thanks for the security Information ,

Now i in another fix with the second part,

I have created the USER ID and password for the table, when a person logs
into the table it should display his/her name in the FORM, and when a data is
saved the displayed name should also get saved,



'69 Camaro wrote:
Hi.

1. To give admin & user access
-- User = read / write (should not be able to delete or update information
[quoted text clipped - 5 lines]
i
dont want that to happen!!

If a user has write permissions on the file, then he can update and delete
data in the file, unless Access User-Level Security is implemented. If you
have a method that prevents these updates and deletes without User-Level
Security being implemented, then please share it with the rest of us,
because you're the first one who's ever done it, and we'd like to pat you on
the back.

Or perhaps you would like to reconsider User-Level Security. One may
download the Security FAQ, which provides instructions on securing your
database and includes a number of handy code procedures, from the following
Web page:

http://support.microsoft.com/?id=207793

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

Hi All,

[quoted text clipped - 17 lines]
stored
in the table!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200701/1

.

Relevant Pages

  • Re: RWOP queries for back-end secuirty: easy/hard? slow/fast?
    ... user-level security that prevents viewing/importing of data by ... Jet user-level security that are left out of all the documentation ... from creating a new database while logged in with a specific mdw. ... can't create a new database while joined to your secure mdw then ...
    (comp.databases.ms-access)
  • Re: Microsoft has utterly failed with Access 2007
    ... I can't answer on Microsoft's behalf, but Access User-Level Security really ... Any idea why MS did away with user-level permissions? ... our database from Access 2003. ...
    (microsoft.public.access.modulesdaovba)
  • RE: how can I remove user level security that I set up
    ... If you used the user-level security wizard and have decided you no longer ... Once you are sure you do, rename the .bak file to a .mdb file. ... database, the workgroup file, which is probably called "Secured," etc.). ...
    (microsoft.public.access.security)
  • Re: Can you password protect a field in Access?
    ... Have you put user-level security in place? ... users, tie the database to the workgroup, etc. ... You'd have to set the queries to Run with owner's permission and ...
    (microsoft.public.access.tablesdbdesign)
  • RE: How to allow users to change their password?
    ... All of the password text boxes will have the ... > be set up to provide the Security dialog window for password changes. ... >> name/password first. ... > See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.security)