Re: Database, its security and a server.

Tech-Archive recommends: Fix windows errors by optimizing your registry

"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
news:%23$on9I0LHHA.5000@xxxxxxxxxxxxxxxxxxxxxxx
If they're able to get into it without getting a log-in prompt, then you
didn't apply security correctly.

Make sure you've read
http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq.asp
thoroughly several times.

Look in section 1 (What are the steps to help protect a database?). I'm
guessing you missed step 6 (Remove the Admin user from the Admins group so
that Admin is a member only of the Users group.) Because you didn't do
that, and the users are using a different MDW file than you used to secure
the database, they're all getting in as Admin (the default user id)


Just to add to Doug's response, you should join your workgroup on a
session-by-session basis using a shortcut with a command line formatted as:

"Full path to MSACCESS.EXE" "Full path to your database.mdb" /wrkgrp "Full
path to your WIF.mdw"

including quotation marks. That way users won't be prompted to log on to
"unsecured" database files.

Regards,
Keith.
www.keithwilby.com


.

Relevant Pages

  • Re: How can I stop people have access to my MS Access Tables and Queries via Import?
    ... My objective is to prevent an average user from being able to gain ... Can I password only the Admin leaving the Users with Full data ... 3.If I do manage to do 1) and 2) above can a user delete the MDW file ... to gain access to my database or will the database cease to function? ...
    (comp.databases.ms-access)
  • Copy secured database to include security
    ... What do I have to do to get a secured database to work on another computer? ... needed to set the security on both Front End and Backend. ... mdw file (Don't know if this is a good idea or not but wanted to keep files ... I then have an Admin ...
    (microsoft.public.access.security)
  • Re: Sorting out security
    ... > MS Access security. ... > created a new workgroup, added a password for the Admin role, added ... > remote logins to a secured database. ... The location of the current workgroup file is recorded in the ...
    (microsoft.public.access.security)
  • Re: Access security - is it just a joke?
    ... If the mdw file is available, the $12 software will hand you the ... the more expensive tool could remove the User Level Security ... Admin is recognized in access from ANY workgroup file. ... "Admin" your database is not secure. ...
    (microsoft.public.access.security)
  • Re: HELP! Access no longer recognizes me as administrator
    ... >points to your .mdw file to open the database. ... >that .mdw file, then you will need to use the XP ... >database doesn't recognize the passwords for anyone but ... >> Are you a member of the Admins group? ...
    (microsoft.public.access.security)