Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: Securing db with a workGroup File

    I have a db that someone set up and it has a workgrp file for security,
    I would like to create another database and use the same Work group file for security. How do i do this?

    I clicked the security wizard and got the msg :

    You must be a member of the Admins group to run the security wizard

  2. #2
    Join Date
    Sep 2004
    Location
    Reston, VA
    Posts
    86
    The easiest way would be to join the workgroup in question, log in as an administrator, create your database, then rejoin the SYSTEM workgroup (the default workgroup).

    1. First, join the workgroup you want to use to create the database. Go to Windows Explorer and navigate to C: > Program Files > Microsoft Office > Office > MS Access Workgroup Administrator. Open the shortcut and select "Join". Then navigate to the folder where the workgroup you want to use is located and select it.

    2. Create a blank new database. After the initial save, you will be asked to log in. You will have to log in as a user with administer rights in the workgroup you've joined. Save the database after you've logged in and close it.

    3. Rejoin the default Access workgroup. Open MS Access Workgroup Administrator again, select "Join" and navigate to C: > Program Files > Common Files > System > System.MDW. Rejoin that workgroup and exit the program.

    4. Create a shortcut for your new database that references the workgroup (just make a copy of the shortcut I presume you're using for the current database and change the command line parameters) and login as the administrator. Then you can create your objects, assign permissions, etc, ad infinitum.

  3. #3
    Join Date
    Sep 2005
    Posts
    313
    Can MS Access with user-level security for only the file we setup?

    Because I setup user-level security in one file, after done that, it affect other files, when I open other files, it needs username and password.

    Therefore, I need to re-join back to system.mdw file, then the prompt does NOT come out.

    But, if go back to open the file with user-level security, then need to re-join the Secured.mdw file.

    Can MS Access handle 2 .mdw files?

    I mean that "Can MS Access only specify the file I setup user-level security?" Other files do NOT need username and password.

    MS Access can detect that if run this file, then go to "Secured.mdw", otherwise, go to "System.mdw"

    Can MS Access do that?

    Thanks.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    No Access has one security file in any one instance
    You can however specify what workgroup file to use iwhen you open acsess via a shortcut, offhand I think its the /w switch. have a google for access command line switches.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •