Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    214

    Exclamation Unanswered: Please Help!!! Workgroup Security Problem

    Hi,

    I was trying to secure my data base and i clicked the workgroup security. I clicked workgroup administrator and made a new workgroup file.

    Well when i start up my access databse it says i do not have permissions to do anything.

    Can I just remove this and access my database without any security? I dont want to lose my info.

    How do I remove the workgroup security?

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    You need to create a shortcut to your mdb which utilizes the mdw file (most likely the mdw is called System.mdw and can usually be found in a folder.) example of a shortcut file: "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Databases\MyMDBFileName.mdb" /wrkgrp "C:\Windows\Application Data\Microsoft\Access\System.MDW"

    Here's some more info which may be helpful regarding mdw and security: http://www.headwaysystems.com/accessSecurity.htm and http://support.microsoft.com/kb/305542

    Once you open the mdb via the shortcut, you'll get a prompt for the user name and password. Then remove the security of the mdw. You may want to make a backup of the mdw file (don't just delete it.) If the username and password you enter still do not give you permissions, I've attached a utility which lets you browse for the mdw file and see the usernames and passwords in it. Unzip the attachment and open the UPVMSA2K.MDA file to use it.
    Attached Files Attached Files
    Last edited by pkstormy; 12-15-07 at 02:24.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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