> I am trying (unsuccessfully) to add a database to an existing
> workgroup file. I am having continuing problems because I have never
> set up security on a database.  The workgroup I'm am trying to add
> the database to was set up by a previous person and I am familiar
> with setting permissions, adding new users, etc. but I cannot figure
> out what I am doing wrong.  I have read several threads with
> responses from Joan Wild but I can't get it right and am getting
> rather frustrated.
>
> I have visited www.jmwild.com and read the "Access 2002/2003 Security
> Step by Step" but then decided that I would rather add it to the
> existing workgroup.  Is there a step by step out there for adding a
> database to an existing group?  Any help would be greatly
> appreciated!  Thank you!

"Joan Wild" wrote:

> You have an existing secure mdw file that you wish to secure a second mdb
> with, right?
>
> You can create a desktop shortcut with
> "path to msaccess.exe" /wrkgrp "path to secure.mdw"
>
> That will open Access.  Next click on New (to create a new mdb).
> At this point it will prompt you for a username/password - provide it with
> the user who you want to own everything in your secure mdb.
> Next import all objects (File, Get external data, Import) from your mdb.
> Don't forget to click on Options and import menubars and import/export specs
> etc.
>
> Now you have a mdb that is owned by you, using the secure mdw.
> Next you proceed to remove all permissons on all objects for the Users
> Group.
> Next you assign permissions for all objects to the groups you have in your
> secure.mdw
>
> Post back if you're unclear on anything.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> AccessIM wrote:
> > I am trying (unsuccessfully) to add a database to an existing
> > workgroup file. I am having continuing problems because I have never
> > set up security on a database.  The workgroup I'm am trying to add
> > the database to was set up by a previous person and I am familiar
> > with setting permissions, adding new users, etc. but I cannot figure
> > out what I am doing wrong.  I have read several threads with
> > responses from Joan Wild but I can't get it right and am getting
> > rather frustrated.
> >
> > I have visited www.jmwild.com and read the "Access 2002/2003 Security
> > Step by Step" but then decided that I would rather add it to the
> > existing workgroup.  Is there a step by step out there for adding a
> > database to an existing group?  Any help would be greatly
> > appreciated!  Thank you!
>
>
>

"AccessIM" <Acces***@discussions.microsoft.com> wrote in message
news:9BFA3779-7871-4A06-BCA3-4E7BD2E3E4DE@microsoft.com...
>I am trying (unsuccessfully) to add a database to an existing workgroup
>file.
> I am having continuing problems because I have never set up security on a
> database.  The workgroup I'm am trying to add the database to was set up
> by a
> previous person and I am familiar with setting permissions, adding new
> users,
> etc. but I cannot figure out what I am doing wrong.  I have read several
> threads with responses from Joan Wild but I can't get it right and am
> getting
> rather frustrated.
>
> I have visited www.jmwild.com and read the "Access 2002/2003 Security Step
> by Step" but then decided that I would rather add it to the existing
> workgroup.  Is there a step by step out there for adding a database to an
> existing group?  Any help would be greatly appreciated!  Thank you!