Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Thanked 0 Times in 0 Posts
    I have about 5 secured databases using a specially created workgroup file that is joined with the workgroup administrator. In 2000, login prompts show up whether they are actually secure or not due to being joined by the workgroup administrator. These files are in Access 2000. I am attempting to change to Access 2007. Any file I open in 2007 that was not secured opens fine and all info is available. All the secured databases give me the following error message " You do not have the necessary permissions to use "File Name". Have you system administrator or the person who created this object establish the appropriate permissions for you."

    I have tried changing some settings on security while opening the files in 2000. This does allow me to open in 2007 but is causing other issues. Please advise of the correct work around in this situation.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Mt Macedon, Victoria, Australia
    Thanked 45 Times in 44 Posts
    I never join workgroups.

    Instead I open secured databases using a shortcut that points to the relevant workgroup info file.

    The structure of the shortcut is:

    path to Access executable path to database /WRKGRP path to workgroup file

    You can optionally add /user and / pwd switches as well.


    "C:\Program Files\Microsoft Office2010\Office14\MSACCESS.EXE" "D:\john\Access\Sample\SampleFrontEnd.mdb" /WRKGRP "D:\john\Access\Sample\sample.mdw" /user Enter User name

Posting Permissions

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