Re: Multiple db's with shared mdw

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 05/21/04 

Date: Fri, 21 May 2004 11:14:11 -0400

AdmSteck wrote:
> I have created one database on our network and have the security set
> up the way I want it. You must use a shortcut to refer to the
> workgroup file which is also on the network. Now I would like to
> secure other network databases with the same workgroup file. What is
> the easiest way of doing this?

Assuming these other network databases are currently not secure, you would
join the workgroup file used to secure the one database and then secure the
rest of them.

You join a workgroup by using the workgroup administrator (in 2002/2003 it's
in Tools, Security, Workgroup Administrator; prior versions you go to Start,
Run, and wrkgadm.exe). 

-- 
Joan Wild
Microsoft Access MVP

Relevant Pages

  • Re: Workgroup files and Open/Run in 2002
    ... then your database isn't secure. ... Security was the main area that I didn't get too much into until ... individual's computer* to join the workgroup file that these 6 DB files are ...
    (microsoft.public.access.security)
  • Re: Security - Security & User Accounts
    ... You are currently joined to the workgroup file you secured ... password set so Access silently logs you into the database ... and then how can I set up secure logins for ...
    (microsoft.public.access.formscoding)
  • Re: Locked out of database
    ... Because most people do not properly secure their databases, ... suggestion I would make is to join the default workgroup file ... Another option is to create a new database and try to import the objects. ...
    (microsoft.public.access.reports)
  • Re: Bulletproofing database with .mde file
    ... malicious intent who is also a legitimate user of your database (ie. has the required folder ... "Normal users (in any workgroup file) will not be able to change the setting." ... that Access security simply raises the bar. ... John made no indication that his database was secure, ...
    (microsoft.public.access.gettingstarted)
  • Re: Bulletproofing database with .mde file
    ... malicious intent who is also a legitimate user of your database (ie. has the required folder ... "Normal users (in any workgroup file) will not be able to change the setting." ... that Access security simply raises the bar. ... John made no indication that his database was secure, ...
    (microsoft.public.access.security)