Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Posts
    9

    Unanswered: Help with Workgroup Admin

    Hello,

    I am probably missing something obvious. I have a Access 97 db that is secured. I added several new users through Access' through User and Group Accounts. The users are entered and assigned to a group. I went to the user's machine and used the Wrkgadm.exe to join the new user to the existing workgroup. It properly joins it, but the user is unable to log in. I opened up the Workgroup Information file to find none of the new users appear in it even though I can see their accounts through User and Group Accounts.

    Do I have to delete and re-create another workgroup to get the new users properly added, and then rejoin all of the existing users to it again?

  2. #2
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    When you add the users to security at your machine, you are adding them to the security (admin) file on your machine. They have a separate file on their machine. In order for this to work, you need to copy the file from your machine to theirs. Good practice to put this new workgroup file into the same directory as the database, then in the shortcut to open the database, you would reference the workgroup file and it's path. Look in Help for information on how to reference the workgroup file and path. Use Command Line to look up this information.
    HTH,

  3. #3
    Join Date
    Nov 2002
    Posts
    9
    The Workgroup Information file is in the same directory as the database. That's why I am so confused. If I open it up that info file, the new users are not in it.

  4. #4
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    Is this file on the network? Do you have reference to this file in the shortcut to open the database?

  5. #5
    Join Date
    Nov 2002
    Posts
    9
    I think I figured it out. For some reason I (the admin) was no longer apart of the Workgroup Info file. My machine was pointing to the generic one on my hard drive. I rejoined the correct file and see that none of the new users are in it. I think I can handle it from here, Thanks so much.

Posting Permissions

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