Re: Basic security questions

"Amy Blankenship" <Amy_nospam@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ec$zgi2oFHA.3756@xxxxxxxxxxxxxxxxxxxxxxx
> Hello, all;
>
> Basically what I want to do is have my database have two
> password-protected users: One that can see everything and one that I just
> show the forms to. I am having conceptual problems with the whole security
> scheme + Access thing.
>
> In an ideal world, I'd like to be able to hand the Access file (by itself)
> to the client, plus the two user names & passwords, and have the user in
> question be able to open the database in the appropriate view. Sounds
> simple enough, but when I crack open the help, it seems that all the
> password protection stuff wants this workgroup definition file thing.
> Isn't there any way to just set up users with passwords that are saved
> with the db itself?

You want an admin account (to see the database window, "everything") and a
user account? That is fairly simple and implies that one of your clients
users is experienced enough to set up the necessary shortcuts depending on
drive mappings. The online help is woefully inadequate and you need to
reference the MS FAQ - link on my website. Be warned though, the FAQ is
"all killer, no filler" and you must follow all the steps. My step-by-step
example may help too, but always work on copies of you files in case you
lock yourself out.

>
> Barring that, I'd like to have the database look for its workgroup file in
> the same directory as itself. How would I specify a relative path for the
> workgroup file for the "b" option, assuming the "a" option isn't possible?
>
The path to the workgroup file is defined in a shortcut in the format:

"Full path to MSACCESS.exe" "Full path to your app.mdb" wrkgrp/"Full path to
workgroup file.mdw"

HTH - Keith.
www.keithwilby.com


.

Relevant Pages

  • Re: Security Blunder
    ... passwords I setup dont work... ... but part is stored in a workgroup file. ... >> database on my system...All I get is the logon window with ...
    (microsoft.public.access.gettingstarted)
  • Re: How secure is a secured database?
    ... I'm pretty confident that I've covered the guidelines in the Security setup ... While the main database will have the sensitive cost issues - i.e. their ... the plaintext passwords from a workgroup file. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Pathname to access and usernames in shortcut
    ... >> network drive (for maintenance reasons initially, ... >> using usernames but no passwords. ... change their passwords within the access database (they won't know how ... >> gets the current username from the system and then calls access (via the ...
    (microsoft.public.access.security)
  • Re: security issues
    ... It was obviously never meant to be; multiple defences against it being ... The Ubuntu installer uses a framework called debconf to do ... when you're asking for passwords ... you take a lot of care to clean them out of the database ...
    (Ubuntu)
  • Re: Locked Out
    ... deleted because my database was corrupted. ... to put in my passwords or anyone elses (I set them all up so I know ... System.mdw is the default workgroup file. ... Try searching your computer for all files ending in .mdw, then try joining those workgroups and logging in. ...
    (microsoft.public.access.security)