Re: Workgroup Permissions

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

From: Graham Mandeno (Graham.Mandeno_at_nomail.please)
Date: 03/07/04 

Date: Mon, 8 Mar 2004 10:08:17 +1300

Hi David

You must open the database using the workgroup file (.MDW) that was used to
secure it. Create yourself a shortcut with the following target line:

<path to msaccess.exe> <path to database> /wrkgrp:<path to workgroup file>

For example:

"C:\Program Files\Microsoft Office\Office\msaccess.exe"
    "C:\My Documents\My Database.mdb"
    /wrkgrp:"C:\My Documents\My Security.mdw" 

-- 
Good Luck!
Graham Mandeno [Access MVP]
New Zealand - Home of Lord of the Rings
"David" <columbia1730@sc.rr.com> wrote in message
news:k6uj409u48kmns2va3b2aukt91vipjgafi@4ax.com...
> I have an Access 97 database with workgroup security.  I may or may
> not be able to remember the log in passwords.  However, when I start
> the database in Office 97 under W98 or Office 2003 under XP Pro, I get
> the message that I do not have permissions on the switchboard or it
> cannot load something.  It never gives me the option to enter a user
> name and password.  Also, I cannot import into another blank DB.  I
> get the message that I do not have the permissions to do so.  I have
> looked everywhere and cannot find a solution.  Any thoughts?
>
> David

Relevant Pages

  • Re: New to security have questions before plunging
    ... Create a new workgroup file for your application. ... > permissions, then have them place that in the same folder as the BE. ... Don't use terms like "the Admin". ... Passwords identify users, not groups. ...
    (microsoft.public.access.security)
  • 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: Basic security questions
    ... > question be able to open the database in the appropriate view. ... > Isn't there any way to just set up users with passwords that are saved ... How would I specify a relative path for the ... The path to the workgroup file is defined in a shortcut in the format: ...
    (microsoft.public.access.security)
  • Re: Trying to program workgroup security using DAO... Help!!
    ... After you created a new workgroup file, you then created a new user to be a member of Admins. ... Here are the steps I've taken to secure a target database (which is ... Assigning permissions. ... Assigned all specific permissions to objects for the new groups I ...
    (microsoft.public.access.security)
  • 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)