Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Delta, Br. Columbia
    Posts
    116
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Access Security (2000)

    I have just taken over a database for a new client. They use security but the previous individual did not appear to print out the report showing the details of the WorkGroup file. I am now trying to find out stuff like Workgroup ID Group ID's etc. The wizard will not let me Modify Current WorkGroup Information file even though I am logged in with Admin permissions. I have also tried with no specific login (i.e. no password for Admin). Any ideas on how I can get at this information so that a record can be made and kept in case of disaster?

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Security (2000)

    To my knowledge, you can't. The Workgroup ID and User/Group Personal ID's are kept encrypted for security and there's no functionality in Access to display them.

    You can certainly find out the user names, group names, and access rights if you're logged in with Admin permissions. So, the easiest way might be to import everything into a new, unsecured database, create a new workgroup (and record the Workgroup ID) and recreate the security.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Access Security (2000)

    Douglas is correct - if the database was properly secured, you can't extract any information about Workgroup or User IDs. On the other hand if it wasn't properly secured you may well be able to get in. There is probably a Master user ID in the system that is other than Admin, and if you can identify that login and crack the password, then you can begin to manipulate the security so you can import everything into a new database and redo the security. Good luck.
    Wendell

Posting Permissions

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